Recent content by JtheRipper

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.