Find Single use plans in Plan Cache

This script will return all the Adhoc Single use Plans currently in your Plan Cache.

It also excludes Plan Shells created from auto/forced parameterization. Works for 2005/2008

Backup All Databases

this script helps you to backup from all database except of sysDatabases

Get Scheduled Jobs from Multiple Servers

Script to loop thru multiple linked server and get agent scheduled jobs for the next XX hours.

Get space used by queries in tempdb

See what is taking up space in tempdb.

Dependencies View 2008

Provides a list of dependencies for a stored procedure

Print Text Month Calendar

This function return the text format of a month calendar. It could be useful for sending through emails when you do do not have other tools, but T-SQL to send text emails.

Scripting CREATE INDEX Statements Automatically From Your Tables

Stored proc for scripting out full CREATE INDEX statements from your table indexes with all filegroup, filter and WITH parameters.

Intelligent Index Reorganize and Rebuild Script - v1.0

This script will provide a dynamic mechanism to decide between REBUILDING an index or simply REORGANIZING an index. Tested and approved for SQL Server 2005 & 2008 Standard or Enterprise or R2.

Script for no of Index in a table

This script will tell you how many indexes there are for a single table and also it specifically shows how many non clustered index, and also which tables have a heap index.

Top 10 Wait State Issues Reporter

This script will produce the top 10 wait state issues along with their descriptions.