Ah, I haven't done 4 days a week at home. I work 7 days a week, probably 50-51 weeks a year now. Probably too much if you ask my wife.

I...

Good to hear some of you getting away. And nice one, blandry. We went on a couple vacations and the kids struggled without the xbox/ipod for a day, then they...

What's the volume of activity? I'd lean towards storing a balance for a couple reasons

- space is cheap

- Unless this is a really busy app, the calculations shouldn't impact performance.

-...

Doh! Eyes getting old. Can't believe I missed that.

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.