Inside the SQL Server Query Optimizer

So how does SQL Server pick which plan to run?  If you've ever wanted to get a better understanding of how the Query Optimizer works, this is the talk to attend.  Come listen to a member of the Query Processor development team explain how a query goes from SQL to the final plan.  This talk will cover conceptual topics like how query trees are built and how the optimizer stores all of the alternatives it is considering.  Additionally, the talk will examine examples in areas including index matching, parallel query generation, and update processing so that you can apply these concepts to better debug your own queries using the same techniques.

Conor Cunningham

Conor Cunningham is a Principal Software Architect at Microsoft on the SQL Server Query Processor Team.  He's worked on database technologies for Microsoft for over 10 years and is holds numerous patents related to Query Optimization and Query Processing.  Conor is the author of a number of peer-reviewed articles on query optimization techniques.  Recently, he authored a chapter for the book "Microsoft SQL Server 2008 Internals" on how the Query Optimizer works.  He publishes a blog called "Conor vs. SQL" (http://blogs.msdn.com/conor_cunningham_msft/default.aspx)  where he answers questions about databases.

Conor Cunningham's blog http://blogs.msdn.com/conor_cunningham_msft/default.aspx

---

Downloads

File Type Ext ContentName Presentation .pptx Presentation

<< 1 >>

---

Other sessions from this conference

Denormalisation –having your cake and eating it.

Design patterns for SSIS Performance

Designing and Tuning high speed data loading

Event Driven Cube Performance and Security Monitoring

Fast Track Foundations: Get Serious about Sequential I/O

Getting Started with SQL Azure

High Availability in the Real World!

High performance functions

Improving Database Performance by Removing the Database

Introduction to Performance Tuning Analysis Services 2008

Lessons Learned from 128 Core OLTP Testing

Make your DBA life better using SQL Server technologies - notes from field & best practices

Monitoring and Tuning Parallel Query Execution

Non-Functional Dependencies - A talktorial on getting performance and scalability right through proper Database Design and understanding Set and Relational theory

Optimizing tempdb and temporary object use

Performance Management for SQL Server with SCOM 2007

Performance Monitoring & Tuning - Documented Tips & Tricks

Performance Troubleshooting made easy with PAL

Photograph: SQL Server Crash Dump Analysis

Scaleout scenarios with Service Broker

SQL Server 2008 Reporting Services Scalability and Performance

Supercharge MDX performance using MDX Studio

Transaction Log Performance Tuning, Stop shouting Timber!