It is possible that there wasn't sufficient free space to make a big difference in the fragmentation, or that the SAN somehow interferes.

Which product did you use? The built in...

Good advice above. Best reason to do system dbs? The server crashes and you need to restore elsewhere. You need master and potentially msdb to do this.

If you do that,...

Wow, no idea what would be wrong. I've never seen the order of tables matter, and I'm not sure why you get different results.

Are these in the same SSMS window?...

Randy,

Thanks for the links and I'll check them out!

good point and I don't disagree that nuclear has dangers. However chernobyl was amazingly poorly handled. Bad design, things switched off, it's incredible they didn't have more accidents.

I don't think...

I have edited your post because it was too long and causing issues. I found > 67kb worth of a stored procedure.

No one is going to tune something that long....

Chris,

not saying you're completely wrong, but you're quoting journalists, who may or may not be correct. This whole thing is an opinion.

Loan guarantees are made all the time, on all...

Thanks for a great summary!

Chris,

not saying you're completely wrong, but you're quoting journalists, who may or may not be correct. This whole thing is an opinion.

Loan guarantees are made all the time, on all...

SP3 is being worked on, no dates yet, but the last guidance in June or July was that it would be out before 12/31/08

Please post in the appropriate forum. the names are at the top.

Moved to Report Development.

I've worked David's schedule, which is nice, every other Friday off, half staff each week.

I've worked 4 10s and those 10 hour days can be long, however it depends...

You can set performance counter alerts in Alerts to let you know things, but be careful. The CPU will jump to 100% often on a busy server, and that doesn't...

I've used views in both ways, though typically we've named them vXX, so that we know they're views. If you use one, you have to understand what's underneath. Typically I...

It's a self join. You may need information from two rows.

A simple example is an employee table that has a manager column. The manager column references the ID of another...