July 18, 2008 at 7:09 am
This is a good article. I can see why it was reprinted. I'd like to see an update. Things are just a little different in 2005/2008. Those differences, some of them cosmetic, such as the change from bookmark lookup to RID lookup in the execution plans, would change some of the details of the article as well as some of the methods of correction (INCLUDE has been mentioned several times).
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 12, 2010 at 12:20 am
Firstly , thank you for explaining Bookmark lookups with such clarity !
I have the same question as SSC-Enthusiastic , how many covering index can we really afford to create ?
October 12, 2010 at 12:23 am
Hi Markus ,
Could you give us some pointers beyond this article since you
mentioned that you've just dealt with the same at a large scale
Thanks !
Viewing 3 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply