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

Just a stab at automating index maintainenance in SQL Server 2008  Read more...

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

Reports stats on what the query optimizer records in the DMVs as missing indexes and what it says the cost savings will be if they were present. Can limit by table / schema name patterns.  Read more...

Reports index stats, index size+rows, member seek + include columns as two comma separated output columns, and index usage stats for one or more tables and/or schemas.  Read more...

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

Using this script you can create a list of sql commands for foreign keys manipulation.  Read more...

Index maintenance procedure using rebuild or reorganized based on fragementation level.  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 reindex (online) any index eligible to be reindexed online. Accepts a day of week parameter for full offline reindexing.   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...

This view reports almost everything you want to know about your indexes  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...

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...

Reports index length stats for indexes who's lengths exceeding parametrized thresholds (defaults to 0 - get all) for total length and seek length, optionally filtering schemas and tables.  Read more...

Just a stab at automating index maintainenance in SQL Server 2008  Read more...

This script will reindex (online) any index eligible to be reindexed online. Accepts a day of week parameter for full offline reindexing.   Read more...