There are rollforward messages in there, if they were large transactions, they could have caused some disk activity.

It seems like most people want a segregated section. That's not a bad idea, and I'll kick it around with the publishing team here.

I do like to run articles...

Check the default trace for that time. See what might have been running.

SQL will use all resources if they are needed, so I'd start by trying to determine what might...

I've avoided money as I'm not sure if provides benefits over the numeric types. It also limits me, and I prefer to not be limited. I let the application handle...

The compatibility level determines how the code is interpreted by the server. It allows keywords that did not exist in 2000 (or 7) but do exist in 2005 to still...

If you are on SQL 2000, I'd use GSquared's idea and make sure that you secure the keys well that are used in the DLLs. If you have them protected...

You need to look in the properties for each instance to determine what the memory settings are, not the Windows System Monitor.

This is a belated honeymoon with my lovely wife, so I don't think I'll be doing any work.

I'd love to come over sometime, just not sure I can get the...

Roy Ernest (1/8/2010)

---

On another note, You guys should take a vacation to this tiny island during new year. You will the whole island lit up at 12 mid night with...

I haven't seen GI Joe, but it looks cool. Working through Angels and Demons on most of my runs now, but might try GI Joe after that.

I think you'd have to do something like the ping test listed, writing to a file, to help determine this.

What does the process do exactly in terms of calling sprocs?...

Thanks, Paul.

I added a note to your blog as well. If that's correct, I'll edit the article to make sure people understand. I think the article is a little ambiguous...

If you have databases in simple mode, you do not need log backups. The checkpoints should mark the log as free. I'm not sure why you see this error in...

Doh! It's fixed. I must have made a mistake when I changed the question.

It now shows predicate as the answer. I'll fix points.

the answer is predicate. It has not changed. The change from

"IN"

to

"columnX IN (x, y, z, ...)"

Makes it a predicate.