I think previous posters have said all that is needed. Either option 1 or option 2 are correct as there is no ORDER BY clause. It would be...

If you have multiple files in your filegroup, then using fragmentation stats to decide if an index needs maintenance will not work.

Fragmentation stats work well with a single-file...

There is no inherent need to run these jobs in a single stream or in multiple streams. You just need to be aware of the impact running multiple streams...

IMHO you should stop the index rebuilt in the maint plan and do it table by table.

After this has been done, look at the size of your largest...

Good article!

I tend to put a copyright notice on all my scripts, and state they are distributed under the Ms-Pl License. I sort of hope people will Google 'Ms-Pl...

If you do a REBUILD INDEX of all your tables in a single process, you are likely to end up with double the database file size you really need. ...

Regarding the growth settings, I agree It Depends. Some people advise proper capacity planning and setting zero growth, some advise setting an appropriate growth increment for the file size.

Where...

You need to build the Windows cluster first. Then you install SQL Server in cluster mode.

If you now have two servers that are not in a Windows cluster, the...

This could be a schema issue. One thing you should do is read what Books Online (BOL) has to say about schemas.

If the dbuser account in the old database...

How often do you do the shrink? If you do it daily, then stop it running for a week and see what impact this has on your overall file...

You say the disk backups are copied to tape at 11PM every night.

Are you 100% certain this happens every night, and 100% certain it always happens at 11PM.

Or...

Forcing a log truncation is never a good idea, except in an emergency situation.

Did you find out why replication had not procesed some of your work? If not, then...

You should not shrink a database file or a log file if you expect it to grow again within 3 months. Shrinking a database mdf file causes internal disorganisation,...

Take note of what Edogg says. Shrinking a database file will disorganise the data within the file and cause NTFS fragmentation. Both of these will harm the performance...

It is a good idea to give the DBA group full control rights on all folders containing database files, database backups, SQL Server binaries, etc.