The agent XPs always change from 1 to 0 as the server starts shutting down. It's an effect, not a cause.

What caused the shutdown is another matter. What's the...

There's an option in the profiler gui that sets whether the duration displays as milliseconds or microseconds. It measures in microseconds regardless, as do some of the performance related DMVs

Couple times I had only 2-3 questions on a case study. Is not fun as the time is short. First time I got one of those I hadn't finished reading...

May I suggest, once you've got this mess sorted out, considering table partitioning for such a large table? That way you'll have several smaller tables that appear to be a...

I bought a whole lot too. Close on $400 of books.

I'll be learning from this conference for months to come, especially once the DVD arrives. It was definitely worth...

This may sound like a stupid question, but please humour me.

How do you know you're having performance issues?

Are queries slow? If so, all queries or some? All the time or...

:blink: :blink: You're right. Wow. Certainly puts some perspective on things.

If it hadn't been for the layovers in London the conference would have been longer, but not by much.

Neither do I usually. I found this when I was posting a bug report, of all ironies.

How many rows are in the table now? How many will still be there after the delete? Are there any foreign keys on this table or referencing this table?

If the...

Iterative delete is easy, and often necessary on large deletes. This is how I do it. Others may have their own preferences

DECLARE @Done BIT

SET @Done = 0

SET ROWCOUNT 1000 --...

Run checkdb with the no_infomsgs option. That way all you'll see are any errors, not the detailed breakdown of how many rows are in how many pages of each table,...

This one.

Initially there was one blank line above. I edited 3 times.

p.s. Thanks for the email header. I get to clear out my mail box on monday when I get...

I resemble that remark! 😀 :hehe:

Make the points visible somewhere else (front page) and change the formula so that contributing scripts or articles also counts (probably more than qotd answers and forum posts)

Long. :doze: