Platinum Sponsor

SQL Server Query Tuning

If you have a database driven application which reacts very slowly when the data increases, then you are right in this session! In this session you will learn, how you can tune SQL Server Queries with the information available inside an execution plan. You will see how SQL Server retrieves data from the database file, how SQL Server can join resultsets, and how you can react with indices if you are in performance troubles.

*) JOIN techniques used by SQL Server
*) Table/Index scan vs. Index Seek
*) Avoiding Bookmark-Lookups
*) Index Usage
Tags (no tags)
  • Downloads
    Sorry, there are no downloads available for this session.
  • SpeakerBIO
    klaus_aschenbrenner.jpg
    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.
    http://www.sqlpassion.at
  • Video
    The video is not available to view online.
  • Session Files Explorer
    The network name cannot be found.