SqlShare.com Logo
 
Skip Navigation Links
Home
Video List
Classes
About Us
Login / Register
Subscribe RSS Feed 

Idera Virtual Database

How to Fix a Bookmark Lookup

SQL Server performance tuning guru Grant Fritchey explains how to fix a bookmark lookup - a common cause of poor performance. He'll show you how to diagnose it and how to fix it!

Duration:
1 mins 35 secs
Skill Level:
100
Rating:
4.47 out of 5
Publish Date:
September 09, 2008
How to Fix a Bookmark Lookup Watch Video Now  Watch it later!
Bookmark and Share
 
1=Poor, 3=Good, 5=Excellent

About the Author

Image of Grant Fritchey
I'm currently working for FM Global, an industry leading engineering & insurance company, as a DBA. I've done development of large scale applications in languages such as VB, C# and Java. I've worked in SQL Server from the hoary days of 6.0. My nickname at work is the "The Scary DBA." I even have an official name plate with it. I wear it proudly. I was awarded a Microsoft MVP in April of '09.

References

There are no downloads or recommended reading links for this video

Comments
Leon on 11/2/2008
awesome info.

Stephen Dyckes on 12/9/2008
Another good point to add to this would be if the "covering index" will still be used efficiently when only using the indexed column and not the included columns.

Dave on 12/9/2008
What impact on the physical structure of the index does the "include" impose (i.e. size, performance, etc.).

1F238A13BE on 12/9/2008
Good example. Thank you.

good

Michael on 12/12/2008
Maybe add a brief mention on why NOT to use the included columns. I might think that ALL columans should always be indcluded.

titokapotito on 12/18/2008
Great Tip, thanks for the video.... Looking forward to see more videos in this page

Should note that INCLUDE columns are not supported in UNIQUE constraint definitions but only in CREATE INDEX statements.

tim cronin on 1/8/2009
Excellent



Must Be Logged In
 

How Do I Become a Video Author? |  Newsletter History

Copyright © Fourdeuce, Inc., 2005-2009. All Rights Reserved | Privacy Policy | Terms & Conditions