Search results for query: *

Hi there, Can someone please tell me how do you identify all the virtual IP's defined on a 3 node Sun cluster? Is it as easy as doing a "ifconfig -a" and looking for something specific, or is there a more scientific way? As you can probably tell networking is not my strong point! For what it's...

Hi there, I have a strange problem with my scheduled SSIS package. When I remote desktop into the server using my local windows account user "HOMER\dba", I see my job succeeds (while I am logged in). I can also right click on the job and start it, the job will then run successfully. BUT, when...

Hi, Thanks for the feedback. Got my interactive report running eventually using parameters. Cheers, J.

Hi there, I am VERY new to reporting services, and started playing with it recently. I am also using the lessons on www.databasejournal.com to learn about this product. I have a few questions on reporting server functionality that I hope someone will be able to answer.. Is it possible to...

Hi there, I have a table in SQL Server with a datetime field. I got the data from Oracle using the import wizard. The data looks as follows in SQL Server: 2006-08-07 10:40:00.000 2006-08-07 10:45:01.000 How can I change this to display as: 10:40:00.000 2006-08-07 10:45:01.000 2006-08-07 In...

Don't want to change my field type .... You don't get half a run. hehe Thanks, J.

Hi, Thanks for all the VERY quick replies! This works now: create table mytbl(name varchar(20), game int, runs int) select * from mytbl insert into mytbl values ('John',2,5) select cast(avg(runs * 1.0) as decimal(10,1)) from mytbl Bizarre that you have to multiply with "1.0" to get the...

Nope, does not work. I still get the wrong result.

Hi there, I have 2 pieces of SQL that I run in Query Analyzer (SQL Server 2005). The first one gives me the correct result - 1.5, the second one not - 1.0. 1: declare @tmp decimal(10,2) set @tmp=3 set @tmp=@tmp/2 select @tmp ===> 1.5 2: select 3/2 ===> 1.0 I stumbled upon this when I was...

Thanks for the input tsuji!

Thanks PHV... have a star!

Hi, I managed to get this going using VB script. I now have another problem which I hope someone will be able to assist with... The process works like this: 1. Build up a fpt script to get the required files 2. Execute the ftp script 3. <delete the ftp script from the user's pc> -- this part...

Hi there, I need to write a script that has to ftp certain files from 1 server to another. I will hard code the directories, files and the username that will be used in this ftp file (lots of users will be using the same file). The script must only prompt the user for the password. The plan is...

Yes, they're exactly the same, approx 35mill records per month (4 months worth). I also tested using only 1 month's data (SQL and Oracle). J.

Yes, The PK is partitionkey,myotherkey. I also created an intex (tried bitmap and b-tree) on partitionkey alone. Generates stats/histograms. Changed optimizer parameters. Looks like this is one where SQL Server has one up on Oracle.

Have you checked which user you are killing (V$SESSION) ? It is not one of the background processes by any chance ? If not... Then it sounds like some sort of BUG. J.

Hi, Just my 2 cents... We also had lots of problems with Oracle 9i's dbms_stats. There are more than a few bugs in that release that have apparently been fixed in 10G. Just one thing I know of, it is pointless to do a degree=>2 for the dbms_stats.gather_index_stats because it does it in...

Just an update... You can build a materialized view to improve these type of queries which will improve performance a LOT, but I would prefer not to go that route as it would result in a proliferation of materialized views in the database. J.

Hi there, I hope someone can shed some light on this... We have a partitioned table in Oracle, partitioned by month (+- 1 500 000 records per day, +- 35 000 000 records per month) ie. test_tbl: partitionkey number; my_otherkey number somedatefield date; select...

Hi there, I am having problems logging in to my 10G DBconsole. I have installed Oracle 10G on Windows XP. I can successfully open the DBConsole loging screen, but when I type in valid login credentials the login screen just reappears after loading a while. When supplying the incorrect login...