Reports table columns that are not foreign keys but that perhaps should be.  Read more...

This script reports objects that are referenced by and that reference a given database object. When a column name is specified, it also includes results showing how that column is used.  Read more...

A script to get the fragmentation of indexes in a database and then rebuild or reorganise accordingly  Read more...

This script reports table columns that allow NULL values but that currently have no NULL values, making them candidates for adding a NOT NULL constraint.  Read more...

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

Index Maintenance procedure with HTML Reporting capabilities. Please refer to attached script for detailed information.  Read more...

This is a data quality script that locates unused Database Roles for maintenance purposes  Read more...

Tells you how much the databases are using the space on disk taking in account the free space at the end of the database.  Read more...

Auto compression of index, if index includes > 1 million rows.  Read more...

This script lets you to know how much disk space will be left after the next database grow taking in account the free space left in the database.   Read more...

Lists all the tables in a database that do not contain any LOB columns(text, ntext, image, varchar (max), nvarchar (max), varbinary (max) and xml). Useful when rebuilding indexes online.  Read more...

This script will allow reindexing (either rebuild or reorg)  Read more...

This view reports almost everything you want to know about your indexes  Read more...

Auto shrink database files in size increment to a desired file size.  Read more...

Drop indexes no longer being used.  Read more...

Performs a checkpoint or a transaction log backup followed by a DBCC SHRINKFILE on the transaction log to the target percentage specified relative to the total data file(s) size.  Read more...

Following code snippet will selectively rebuild indexes that have been thrashed after a big indert  Read more...

1100 largest indexes by total buffer cache usage; 100 largest tables by total reserved pages; Largest tables in each database with running total of space usage and growth since last snapshot  Read more...

Grows all of the data files in a database based on the greater of a fixed minimum free space amount or a dynamic percentage of the size of the largest table in the filegroup.  Read more...

Grows all of the data files in a database based on the greater of a fixed minimum free space amount or a dynamic percentage of the size of the largest table in the filegroup.  Read more...