Thanks for all the replies and comments, it is much appreciated. The current environment is a very complex one and they don't really want to change any of the code...

I've had this issue before, runnning a query from an Oracle db through DTS. I cannot exactly remember the amount, but it was something in the region of 2000 or...

Bit operations and case statements are not that slow, and any other way of doing it without might prove to be more time consuming.

Temp tables could also slow you down,...

No probs

Do you have any indexes on these tables, and what does the query look like?

You can also set the recovery mode of that database to simple, which will mean not every single thing gets logged in the transaction log.

Just make sure you back up...

In my opinion, it all depends on your application. If you have a transactional system with lots of capturing and inserting, then 3NF at least.

On the other hand, when you...

I know this might be a big no-no for the purists, but an easy thing to do is run the query a couple of times while recording a trace. Then...

Also, when writing any queries for that table be sure to use the with (nolock) option next to your table name. This will ensure that no locks will be held...

hehehe...definitely looks like a homework question. You'll have to buy all these okes a beer if you pass Sasha.

Hi Richard,

Nothing wrong with how you do it here. What I sometimes do in this kind of scenario is to create a temp table, insert all the base data and...

Richard, can you maybe give us the query that you have written so far...it will just make it easier toe either spot the mistake or help with the correct way...

It sounds like the DTS package might have been saved as a structured storage file, and not as part of the service itself. If you are trying to open this...

Hi,

I just had a quick look at this, but the problem seems to be in your join conditions. You are joining the tables on COMPANY only, and from what you've...

Hi Tony,

The problem is that you are using quotes to denote string values, and that is why you get the "" (empty string) in the text file. If you set...