SQL Server Performance Tuning and Optimization

SQW08 Inside the Query Optimizer

11/20/2013

11:00am - 12:15pm

Level: Intermediate

Bradley Ball

Sr. Consultant – Premier Support for Developers

Microsoft

When it comes to SQL Server one of the biggest requests you hear is "How can I make my Query Run FASTER!?" The answer: understanding the first step in that process is understanding the Query Optimizer. Understanding the Optimizer beings with knowing the Rules. The way our queries are written reflect directly on the output that we get. In this session we will look at the rules in SQL Server, write queries to show those rules in action, and walk out with a better understanding of how the Optimizer works.

You will learn:

  • The stages and processes involved with Optimization.
  • How the Query Optimizer Rules affect Execution Plan outcomes
  • How the Optimizer Rules can be used to your advantage