There's a lot more performance improvement that meets the eye with the use of qualified name, there's a lot to do with plan reuse to.

All the system dbs have an sid of 0x01

Yup they're automatically generated stats. Indexes don't delete/generate themselves whenever they want.

Damn we're geeks .

I just corrected his typo... he deserves the credit this time.

Ok, so if the file is 10 GB, how much of that space is free, unsused?

That's exactly why we test our script on a recent backup of the server to make sure nothing screws up... but thanx for the feedback, I never thaught of those...

Don't the recordset tools have order methods in 'em?? Why don't we use 'em?? .

Seems to me like a pretty simple task... and it's not 10 mb of ram that'll kill the server.

Yup... that's gonna be a fun one to correct .

Sorry to hear you're screwed .

Try converting to 9.0 when Yukon is out .

Never too late to learn... the day I'll stop learning, I'll be dead.

Convert the sps to functions (try to keep the select part outside of the function) so the function can be deterministic (runs MUCH faster).

then : Update table set Amount...

Let me state the obvious :

ALTER TABLE... alters the table

Thanx for the info .

I'd be surprised if we couldn't .