Index best practice resource

201408
SQL Server Index Design Guide

SQL Server Best Practices Article - Published 2007

SQL Server 2008 Microsoft Certified Master Readiness Videos
Indexing Strategies
Index Analysis
Indexing Strategies Demonstration
Index Internals
Index Internals Demo
The Clustered Index Debate

why my index seek change to index scan when return result increase - will update

SQL 2012 non cluster column store index - will update
SQL 2014 cluster column store index - will update