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

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

Shows awesome view of columns with constraints and indexes and foreign keys to spot errors fast.  Read more...

An in-depth look at index statistics and how they are used by the optimizer by Josef Richberg.   Read more...

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

Query to save all index metadata  Read more...

drop the primary key name is different for each database  Read more...

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

This script aggregates index usage stats into a view.  Read more...

This procedure disables or rebuilds indexes for a given tablename  Read more...

A quick script to check for fragmentation in a database and generate a list of defrag statments you can run.  Read more...

Index maintenance procedure using rebuild or reorganized based on fragementation level.  Read more...