Extra-Wide Covering Indexes
Video References
These additional references will help you take what you've learned in this SQL Server Video to the next step.
Book References
Inside Microsoft SQL Server 2005: Query Tuning and Optimization
Relevance: Pages 118-121 & 214 provide information about the benefits of covering indexes - including some of the improved benefits offered by SQL Server 2005's INCLUDE statement. Pages 121-124 also provide great information on bookmark lookups as well.
Microsoft SQL Server 2000 Optimization Guide
Relevance: Page 197 calls out some of the trade-offs involved in creating covering indexes - and also lists some best practices for their deployment.
Links / References
SQLMag.com [link]
Relevance: Aviv's full article in the Reader to Reader section of the magazine can be found here. (And make sure to check out the comments for additional information.)
SQL Server Central [link]
Relevance: This great blog post by Ken Kaufman provides a great overview of covering indexes in general and calls out some of their trade-offs as well as some of the improved benefits of creating covering indexes with SQL Server 2005's INCLUDE statement.
