Hi,

It shouldn't take that long. I import csv files into our datawarehouse with a size of about 5GB, and it takes a couple of minutes.

You need to look at...

Hi, it is not necessarily incorrect. SQL server will hold on to allocated memory if there are no other processes requesting memory, and will do so untill another process wants...

In my experience, the following works very well:

• Firstly, you should try and separate your staging area into a separate db. This allows you to have a different backup strategy etc...

Yep, we indeed have a VVLDB...and it makes management and maintainance very interesting. Simple operations take forever because of the pure size of it, and planning becomes essential for even...

Hi,

This is a difficult question to answer and is very specific to the kind of system and business you find yourself in. In my opinion anything that gets to the...

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.