Glad to hear it worked. Did you patch the server first?

SQL Backup from Red Gate is very good about centralizing management of your backups. Plus it has other benefits, like backup compression for 2000 and 2005 databases and backup...

This is a classic "are you sure really need everything, every time" discussion that you should have with your application team. Also, I suspect, it's hard to know based just...

You have to set up the monitors. Start now. For a general set of monitors...

You might see a speed up in the start up process if you have fewer databases, but overall performance wouldn't be affected at all.

Have you looked to see what queries are being run during these times? Sounds like they might be hitting parallelism. It's worth checking to see what they're doing and how...

You're posting in the 2005 forum, you might get answers that are not applicable for the version you're looking for. You'll probably get more help by posting in that forum.

Well, in order to project growth, you need at least two measurements. Let's assume a week apart. Then take the difference and project it in a straight line, multiply by...

As a general rule, yes, but you do need to account for your own individual circumstances, the load on your servers, the number and size of your databases, etc. There...

It has to be something along the lines of which one will the optimizer pick first, but that's so subject to a million different factors, it's still not really...

First a comment, generic procedures that do everything, everywhere, automatically, are notorioiusly problematic. TSQL just isn't conducive to that approach.

The problem you're hitting is that you can't refer to tables...

Not sure about the first one, I suspect there's a different index name in there that is messing it up.

The second question, no update on the stats was needed because...

Most of this is available in system tables. What have you tried so far?

If you are placing a single quote within a string like this : 'O'Sullivan'. It actually has to be marked up like this: 'O''Sullivan' Note, that is two single quotes,...

The only one Gail didn't address is Update Stats. You'd be best to make that a part of the index updates. Frequency really depends on your system, but I'd say,...