Last week, I had published Remove Bookmark Lookup – SQL in Sixty Seconds #089 and I got a tremendous response to the video. Lots of people reached out to me with lots of questions. I have written a follow-up series to this video as well. You may read it here SQL SERVER – 7 Follow Up Answers to Remove Bookmark Lookup. Every day I am getting lots of email about the covering index and how to improve performance so today we are going to see a video about creating converting index to eliminate join and improve query performance.
Covering Index to