Covering Indexes
A Covering Index is one of my favorite performance techiques. B ascially - a covering index is one that completely covers the needs of the query without having to resort tot eh dreaded bookmark lookup. This last weekend I made a ScreenCast about Covering Indexes. Enjoy! And if you have any suggestiosn or requests for more SQL Server ScreenCasts, email me.