Script to reorganize all indexes on all tables in user databases  Read more...

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

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

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

Rebuilds all indexes from all databases over a specified fragmentation threshold.  Read more...

It finds the Indexes on database which needs to be Defragmented and Rebuilds those indexes. Only you need to replace 'database_name' with your database.   Read more...

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

Script to list out all fragmented indexes for a given database, with options to only view them, reorganize them, or rebuild them in one fell swoop.   Read more...

A conceptual proof for a google like search procedure  Read more...

Complete script for index defragmentation and updating stats  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...

In the first time you execute this procedure, might take a long time, but not in the next time. Later you can execute this procedure daily.   Read more...

This script helps to find all columns of an index on a table. Include columns covered (include)  Read more...

A thorough SP for rebuilding indexes.  Read more...

This Script allows you to determine the list of unused indexes in your databases. For sys.dm_db_indexes_usage_stats, make sure that the last rebbot of the service sql allows you to conclude  Read more...

Query to get tables with no clustered indexes(2K5,2K8,2K8 R2)  Read more...

I needed a fast way of creating identical copies of multiple tables. The criteria was to make identical copies of tables for a specific schema. Well there it started.  Read more...

Identifies potentially missing indexes.  Read more...

Finds tables and indexes that do not show up in the usage statistics.  Read more...

Retrieve included columns info as well along with other column list  Read more...