Could you please start your own thread for this. You'll get more replies and reads than if you hijack another.

Strange. I know the query optimiser has changed in 2005 and often picks different plans to what the 2000 one would have picked.

Can you check the execution plan of the...

Is any error been thrown? Does the user executing it have update rights to the table? Are there any triggers on the table that might be rolling back your changes?

Can...

Rebuild all your indexes and update all your statistics.

The upgrade from 2000 to 2005 doesn't do that and I have heard of several issues where queries run slower in 2005...

Not too hard and perfect for CASE. Try this

SELECT CustID, InvID,

 CASE isRegularCustomer WHEN 1...

Dunno. Depends on whether or not you need (business and complience requirement) to do a report on them first.

If not, a SQL agent job, command line doing a delete would...

My guess is that you have c2 auditing switched on. Run sp_configure and have a look at the value of the c2 auditing option.

If it is on, you will...

I have a habit, if I'm sitting in on an interview, of asking a very difficult question related to the position that the person's applying for.

I'm not necesarily looking for...

It's fairly simple

Open profiler and create a new trace.

Connect to the server you want to profile.

On the first screen check the box that says save to table. Enter the table...

I glanced through the dm views and I can't find anything there either.

You can set profiler to log to a table (provided your server's not too busy) and then just...

What data type is calldatetime?

I just got back from leave and Tech-Ed and noticed this

Very nice article.

There's nothing that gets at me more than a harsh or insulting reply to a post I've made,...

My recomendation would be to use profiler.

The event you want is under stored procedures, sp:recompile

You want to catch the object name, the event subclass (which gives you the reason for...

I can't reproduce the problem, but something I saw a couple days ago at teched might help you.

You aren't by any chance connected to a SQL 2000 instance are you?...

Can you post the sp code please?

The only thing that imediately comes to mind is that it was a real table created, not a temp table