If I may, you may want to take a few minutes and read this: The Flip Side.

Unfortunately, there is no context with regard to this error, so actually no, I can't tell you how to fix this.

If sys.sp_reset_connection being executed by one application is causing your global temporary table to be dropped for another application, your other choice is to install a separate instance of SQL...

I have an idea on why the difference between SQL Server 2000 and SQL Server 2005.

One SQL Server 2000, the database engine scanned Table2 once. On SQL Server 2005,...

Here are the statistics io and time results from mine and Chris's fast queries:

(7203 row(s) affected)

Table 'Table2'. Scan count 1, logical reads 168, physical reads 0, read-ahead reads 0, lob...

Query finished, ran 9 minutes 14 secods and returned 7203 rows. Some of the estimated rows are quite high, 9 B for one of them.

I have uploaded my actual...

Chris, Nevermind. I found your post above.

The second query, even with OPTION (MAXDOP 1), is pegging my Dual Proc Quad Core system.

The first query ran extremely fast. I...

Christopher Stobbs (4/15/2009)

---

mmm I'm going crazy here...

Ok with the following query I can confirm that on 200 it takes milliseconds and in 2005 it takes well over 5 minutes and...

Not really sure what "quite...

Here is some code for you to examine and play with. I hope it helps.

declare @StartDate datetime,

@EndDate datetime;

select

...

You indicate an end date in your original post, but I don't see that in your test data. How is this determined or is it passes as a parameter?

Your...

This may be counter-intuitive. on SQL Server 2005, add this to the end of your query: OPTION (MAXDOP 1)

I would still like you to try my other SQL Server 2005...

Take...

Using just the first 2 or 3 values in your test data, could you please provide us with the expected output from the process? This will greatly assist in...

Rowan (4/15/2009)

---

Its a Windows Server 2003 server SP2

Microsoft SQL Server 2005 -...