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

Mid September Free Training from PASS

There's going to be over 30 hours of free online SQL Server training in the upcoming week and you're not going to want to miss out!