SQL Server Index Maintenance Performance Tuning for Large Tables

This article describes a real-world example of performance tuning index maintenance for a large table of approximately 1 billion rows.

Heaps

Understanding Indexes

This article contains an introduction to SQL Server indexes and how they are used in your queries.

Unused Indexes in your databases

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

Indexing Lookups

Query to get tables with no clustered indexes

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

Effective Clustered Indexes

As a guideline, clustered Indexes should be Narrow, Unique, Static and Ever Increasing (NUSE). Michelle Ufford Explains why.

Column Order in an Index

This short article shows the importance of order of columns in an index.

Clustered Indexes

sp_helpindex2

Retrieve included columns info as well along with other column list