Indexes, Indexes, Indexes

This article has a description of an index utilization tool that Ron Johnson uses to analyze the effectiveness and use of indexes in a system.

Finding all Columns of an Index

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

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.