Examining statistics of indexes is useful for optimizing the performance of queries. Statistics help us determine the usage and worth of indexes - one simple method is using the index-related dynamic management view; sys.dm_db_index_usage_stats  Read more...

Paul Randal, former SQL Server Storage Engine lead, brings us a great explanation of how indexes are affected when you alter your schema.  Read more...