Try writing the SQL statement with NO LOCK.  You take the chance of reading dirty data, but normally for reports that's an acceptable risk.

Presumably you are doing this in the context of a data warehouse. If so, you should be aware that this is almost always the most complicated and time intensive...

You don't indicate how you are calling the code, but if you are using ADO you can run the process asynchronously.  Synchronous is the default, which means the machine will...

I my testing of restores, I found it better to backup the transaction log PRIOR to doing the full backup. I can't explain it, but using the way you...

I once used a Cartesian product to create a report to show all our companies instructors and all classes. I then had to match this with another query so...

This is interesting theory, but what about situations such as work orders which are not complete but have a DateCompleted field.  That item is simply not know, and using an...

Hallo Frank,

Irgendwie habe ich diese Ehre vermisst.  Wahrscheinlich hatte ich viel zu tun, um die Reise nach Deutchland vorzubereiten.  In jedem Fall gratuliere ich dir herzlich.  Du hast nicht nur...

I am partly posting a reply because no one else has, though I am unable to find my notes on the subject.

I had to once design a program to take...

I disagree that you can't reach 100% accuracy of the known data.  If the bottom line of the data warehouse doesn't match the inputing systems, then the data warehouse creator...

Can't help you with 1 or 3, other than to say that if you're using MTS I'm pretty sure that the connections are diposed are a time, but if you're...

This article doesn't even begin to address what IT staff, the presumed readership of the article, can do to address the situation presented.  Nothing here about determining measures, level of...

If I understand correctly, you're running a process that, once run, doesn't allow you open excel properly.  If so, in the code, you need to close the application object.  That...

What does the actual performance have to do with the memory usage on startup?  What would be the "wrong situation", as you put it?  That the server is underpowered?  I've...

This is a very interesting thread, but I don't see the relevance of some of the questions, like:

How much memory does SQL use on startup?

I've never had to share an...

If you're not planning to keep the data, and I assume that you are not if you are considering a temp table, I would use the temporary table.  At the...