talltop-969015 (11/11/2009)
Unfortunately, I was not able to read Part 3 as of yet since there seems to be an error on the web page.
That's because it hasn't been published yet.
Use the INCLUDE columns in your NC indexes whenever you can to fix those expensive Bookmark Lookups using the Clustered Index.
Maybe. Just because a query can be covered doesn't necessarily mean it should be covered. As with everything, there are downsides. Covered in part 3 of the series.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability