It appears that your browser does not support JavaScript, or you have it disabled. This site is best viewed with JavaScript enabled. If JavaScript is disabled in your browser, please turn it back on then reload this page. If your browser does not support JavaScript, click here for a page that doesn't require javascript.

The dangerous beauty of Bookmark Lookups

You know Bookmark Lookups in SQL Server? You like their flexibility to retrieve data? If yes, you have to know that you are dealing with the most dangerous concept in SQL Server! Bookmark Lookups can lead to massive performance losses that blows up your CPU and I/O resources! Join me in this session to get a basic understanding of Bookmark Lookups, and how they are used by SQL Server. After laying out the foundation we will talk in more details about the various performance problems they can introduce. After attending this session you have a better understanding of Bookmark Lookup and you are finally able to tell if a specific Bookmark Lookup is a good or bad one.

Klaus Aschenbrenner provides SQL Server Consulting services across Europe and the US. He helps people around the world to understand, use, and run SQL Server installations in their environments. In the years 2004 - 2005 Klaus was honored with MVP awards from Microsoft for his tremendous support of the .NET Community. Klaus is also the author of the book Pro SQL Server 2008 Service Broker (ISBN 1590599993) published by Apress in August 2008.