The code can be optimized if rewritten as:

Since NULL will not be greater than anything the call to ISNULL is wasteful.

edit: put code inside quote block to...

If you meant SSIS package, and not actually DTS (SQL 2000, 7.0):

kausmail (6/8/2012)

---

I have a DTS package that imports the data from csv file into the table everyday. I Now...

I think so. If I have it, you can change my query to this to see the inner-section (maxDtStart and minDtEnd) where all processes overlap:

DECLARE @dt DATETIME = '2012-06-11 11:32:00.000';

WITH...

One point of clarification on the requirement please, when you say "a common point in time" what determines that point? Will this be for a real-time dashboard in which case...

Hmmm, is your test environment representative of the prod environment in terms of CPU, memory and IO subsystem? I would also look hard at the CPU time (SET STATISTICS TIME...

I would recommend looking into the Conditional Split Transformation to help you parse the file and route each file-line-type onto a different output stream.

Then, when loading your data-lines into...

Here is a good place to start to get some idea of what Microsoft set forth as documented Best Practices when it comes to setting up a DW. It talks...

For those not interested in opening the Excel file here it is:

Just a couple WAGs, you could try importing the entire sheet into one table and then using T-SQL to...

charlesd (6/17/2012)

---

Unfortunately, after checking all the file and directory permissions I was still unable to install SP2.

I got the same error as before. But doesn't the execution of the...

No question, it is important. I just wondered why you singled...

That was my initial suggestion,...

george sibbald (6/16/2012)

---

Another thing... if you are not concerned about which SP you apply (you say you are happy to try SP3) then go for the latest service pack which...

Jeff Moden (6/16/2012)

---

Speaking of "sharp corners", it's a funny thing about adversity and the written word. Although I agree with the author of the following post, how should one...

To add to the modifications Jeffrey mentioned you can also tune the SSIS package's buffer settings (DefaultBufferMaxRows and DefaultBufferMaxSize) to improve performance.

jralston88 (6/15/2012)

---

I'm a relative newbie with SQL Server admin tasks. Recently I noticed that the two prior dba's did not set up DBCC CheckDB for our 2005 and 2008...