Script Center Home > Script Repository > SQL Server > SQL Server 2005

Indexes and Indexing

Sample scripts for working with index and indexing in SQL Server 2005.

•Analyze Index Statistics
•Create/Truncate an Indexstats Table
•Determine Index Cost Benefits
•Identify Missing Indexes
•List Indexes With the Most Contention
•Retrieve Index Statistics
•Retrieve Index Usage Statistics
•Retrieve Indexes Not Used Since the Last Recycle Time
•Retrieve Object and Index Fragmentation Information
•Retrieve Tables, Indexes, Files, and File Groups Information
Top of pageTop of page