No, it's not the same at all. 2005 really is better.

Pull up the execution plan. That will help you find out where to look.

I suspect it's this:

(D.Did in (select max(Did) from D group by Aid) ...

I can't find the documentation. Here's a support article, but it's not what I meant:

http://support.microsoft.com/kb/281671

And Kalen

http://www.sqlmag.com/Article/ArticleID/16078/sql_server_16078.html

Actually, quite a few of us get paid to rewrite 500 line stored procedures. We'll help, but you...

First, I'd try posting in the SQL Server 2000 forums, not the 2005 forum.

Second, there isn't an immediate method to do this. There are some options. If you're running a...

I agree with Matt. There are some fantastic articles right here that will move you along. As for books, Wrox has a decent one called Professional SSIS. The one our...

It really does sound like recompiles either from causes within the code or due to changes in the data. Especially since it seemed to happen over time and somewhat randomly,...

I wish I had a contact or three at MS. I'd love to see this moved up the chain... I'm going to try contacting a couple of people.

It's still Visual Studio.

While GUID's can be a unique value, you didn't put a unique constraint on the key, so when combined with the other part of your where clause, you're probably getting...

It sounds like Steve nailed it in one.

We had a similar issue, waits for compiles, which lead to other waits for compiles, etc.

Our code was actually compiling due to changes...

Ummmm. That was strange. Where the heck did the execution plan go?

If I run this query, I can see it.

SELECT

p.*,

q.*,

...

A log file is a mechanism I'd only use from the application side. If you're capturing error information inside SQL Server, just write it out to a table.

The optimizer, along with a whole of the rest of the engine, was changed between 2000 and 2005. It's not at all surprising that you'll see different execution plans in...

There's not a good source for this information. Experimentation is how I'm getting by.

I can recommend three sources that can help, in addition to posting here (althouth only a...