Compare Patch levels across all installed sql instances

This script allows you to compare patch levels across instances.

Harnessing SQL Server Metadata- Disabling and Rebuilding Indexes

When doing bulk data changes it may be beneficial to disable indexes prior to starting the operation. Fortunately, SQL's rich metadata makes this very easy to automate in a robust fashion.

SQL Server Index Maintenance Performance Tuning for Large Tables

If you think about it carefully, you’ll realise, that index maintenance is necessary and that it makes sense, and that SQL Server is not doing this task automatically according to the book.

Data Dictionary using sys.objects - SQL 2008

Create a data dictionary with two stored procedures using sys objects to view via SSRS (or other reporting tool) report

Update Stats with Reindex

Top Tips for Effective Database Maintenance

Far too often, people who are not trained database administrators somehow end up responsible for a database. They lack the proper training and knowledge to maintain their database, and problems begin to develop. Here’s a primer for all those involuntary DBAs who need a crash course in database maintenance best practices.

Display Job Schedule Description (SQL Server 2005)

The idea was taken from this script: http://www.sqlservercentral.com/scripts/Maintenance+and+Management/61448/

Which did not work in SQL 2005 due to table changes on MSDB

Generate Job Schedule Descriptions

A SELECT statement which includes the alpha description of each job's schedule

Check Availability Window - SQL2k5

This script allows you to check the several availability windows for the current day.

Check Availability Window - SQL2k

This script allows you to check the several availability windows for the current day.