Model DB

Make a 100+ Server Inventory in 30 minutes

Learn how you can generate a server inventory in 30 minutes for all of your servers with this new article from Stanley Chan.

SQL Server System Report

Overview report for tracking key database performance metrics, general system stats, overall activity, and general server info, including: properties and settings, uptime, drive space, DB size allocation, growth stats, backups, jobs, index fragmentation, missing and unused indexes, and much more.

Truncate Transaction - All Databases

Script to help you to truncate TL for all databases.

Resource Governor

Policy Based Management

E K M

Check status of HEAP tables

This SP reports the status of your heap tables. It gives you an overview of fragmentation, ghost record counts and forwarded record counts. Another reason to create a clustered index!

EXECute SQL Commands over entire sets of parameters!

A super-powered EXEC on steroids, the Power Tool every DBA wants for Christmas.

Mission Critical: SQL Server 2008 General Maintenance

This document contains steps that will assist you in the day-to-day SQL Server 2008 RTM Enterprise Edition (non-clustered) operations. It defines the basics of standard maintenance and checks for a single Instance of SQL Server 2008, and should be used as a starting point.