Pre-allocate space? I do that, looking past my thumb at the keyboard with a WAG. I think Derek did pretty good :w00t:

Congrats, Lynn. I'm sure you're very proud of her.

No load meaning no activity at all? If so that's a bug and you should contact MS. However I have seen many, many SP2 installations with no issues.

Very nice writeup. Thanks for the info.

CPU utilization can go to 100% in normal operation. The thing you need to trace and determine is which queries are causing that. You can tune those, or better isolate...

The upgrade advisor should help you.

Don't worry Bob, we'll just update your name to Bob-Hovious-Was-Here 😛

That is strange. I would lean towards some kerberos issue. Maybe the user's DC is off for some reason? Is the user remote?

I think that you get what you pay for. For most 4x4 and smaller machines, it's a retail, commodity purchase. If you are large enough and purchase in bulk...

It's hard to stay in the top 5-10 here since you get points for questions. It seems that we'll have a few people every month answering 500 questions and jumping...

Grant,

You're always welcome to come speak (and ski) at the user group meetings. We have 3 in the same week, consecutive nights. Lynn's in the Springs.

I believe that sys.objects has all objects, but your best bet might be to bookmark the page on MSDN that lists all tables.

A database snapshot is not like a SAN snapshot. Once the SAN snaps the disks, a complete, and separate copy is available on separate disks. That takes advantage of the...

You always want to pass in the data at the lowest level. I assume that you have indexed the mid and pid in the middle table, you'd use those for...

Sorry, I didn't run that script. I didn't have time to dig through it last night before trying it. I've got a more testable instance now and I'll try it...