Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Bookmark Lookups Expand / Collapse
Author
Message
Posted Friday, July 27, 2007 2:10 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 2:07 PM
Points: 1,289, Visits: 2,843
Funny that I just saw this article. We JUST tackled this exact situation in a large SS database last week.  Good article !  I wish i would have had this info two weeks ago.


Post #386001
Posted Wednesday, August 1, 2007 9:09 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, October 17, 2014 3:17 PM
Points: 30, Visits: 298

With SQL Server 2005 you also have the opportunity to Include additional columns in your index.  This is in BOL at:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/d198648d-fea5-416d-9f30-f9d4aebbf4ec.htm

"An index with included nonkey columns can significantly improve query performance when all columns in the query are included in the index either as key or nonkey columns. Performance gains are achieved because the query optimizer can locate all the column values within the index; table or clustered index data is not accessed resulting in fewer disk I/O operations."




Post #387053
Posted Tuesday, May 13, 2008 5:58 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, April 27, 2009 8:28 PM
Points: 161, Visits: 162
Amazing article ....... On similar lines please find another link :: http://blogs.msdn.com/craigfr/archive/2006/06/30/652639.aspx
Post #499488
Posted Friday, July 18, 2008 2:14 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, October 16, 2014 4:46 AM
Points: 5,404, Visits: 1,400
Excellent and very useful article...


Post #536546
Posted Friday, July 18, 2008 7:07 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:06 AM
Points: 13,875, Visits: 28,272
David Tiss (7/27/2007)


Great article, I learned a lot.

I'm wondering if the included column feature in SQL Server 2005 will also help with bookmark lookups?


INCLUDE columns absolutely help with lookup issues.


----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server Query Performance Tuning
SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #536736
Posted Friday, July 18, 2008 7:09 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:06 AM
Points: 13,875, Visits: 28,272
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
The Scary DBA
Author of: SQL Server Query Performance Tuning
SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #536739
Posted Tuesday, October 12, 2010 12:20 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, June 17, 2014 1:44 PM
Points: 7, Visits: 29
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 ?


Post #1002566
Posted Tuesday, October 12, 2010 12:23 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, June 17, 2014 1:44 PM
Points: 7, Visits: 29
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 !
Post #1002568
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse