See if you can get hold of the SQL Server 2005 upgrade adviser. It's probably available for download from MS.

With the testing I'm doing for upgrades, it's not so much...

What does the execution plan look like with the isnull and without it?

If it's a stored procedure, it may be getting a bad execution plan. If the optimiser compiles for...

My main server has 2 heavily utilised large databases and a few smaller, less used ones.

We split the biggest database into 3 data files and put each one on a...

Is there any trigger on the Address table? Are any errors been raised?

Are you using a cursor for the Address update as well? If so, I may have an idea...

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?