PASS Summit 2010
Register Now

ROI Justification



PASS Facebook PASS LinkedIn PASS Twitter

Premier Sponsor:

Platinum Sponsor:
Flush With Cache: What Really Happens Before That Query Runs
When we discuss performance tuning, we often focus on how to make query execution more efficient, and with good cause since execution is the single most important piece of performance tuning on SQL Server.

However, query execution can only begin once query parsing, optimization, compilation and caching have occurred. These steps are generally less well-understood than execution, but can also have a significant effect on the overall performance of your SQL Server.

This session will look at the work SQL Server has to do to produce that executable query plan, as well as choices we can make as database developers that affect the pre-execution stages of query processing. After this session, you should have an understanding of ways to reduce the amount of "grunt work" that SQL Server has to do before it can get down to the business of actually running a query.
Database Development Manager
I am the Manager of Database Development for Registration and Aftermarket Services at My team runs and supports the world's largest Internet domain name registrar, with over 40M domains under management, and our servers conduct approximately 1.5 billion transactions per day I've worked with databases all the time since 1989. I started working with SQL Server at version 4.21a. In previous lives I have been an opera singer and an Oracle MVP (of sorts). In my personal life I try keep time available to enjoy my wife and four kids, and to follow Jesus no matter what.
Register Now for PASS Summit 2010!

  Top Reasons to Attend
PASS Summit 2010
  • Over 160 technical sessions from the world's top SQL Server and BI experts
  • 2 full days of deep-dive Pre- and Post-Conference Seminars
  • Networking with thousands of SQL Server MVPs, experts, Microsoft employees, and peers
  • Face-to-face support with the Microsoft CSS and SQLCAT teams
  • Ask the Experts Lounge
  • And much more!

Gold Sponsor

Copyright 2010 by PASS | Terms of Use | Privacy Statement