L.A. SQL Server Professionals Group

Welcome to the Los Angeles SQL Server Professionals Group

Next Meeting

Thursday,

September

15

Inside the SQL Server Query Optimizer

  • In-Person @ 110 Westwood Plaza Los Angeles, California, United States (map)
  • 18:30 - 21:30 Pacific Daylight Time
  • Language: English

Inside the SQL Server Query Optimizer

Featured Presentation:

Inside the SQL Server Query Optimizer

Benjamin Nevarez

The SQL Server Query Optimizer is a cost-based optimizer: it analyzes a number of candidate execution plans for a given query, estimates the cost of each of these plans, and selects the plan with the lowest cost. In this session I will go into the internals of the Query Optimizer and will show you the steps that it performs in the background covering everything from the time a query is submitted to SQL Server until an execution plan is generated. I'll show you how the Query Optimizer generates possible alternative execution plans, how these plans are stored for the duration of the optimization process, how heuristics are used to limit the number of alternative plans considered, how each candidate plan is also costed, and finally how the best alternative is chosen based on those costs. I will also cover why query optimization is an inherently complex problem and why challenges in some of its most fundamental areas are sti! ll being addressed today.

About Benjamin:
Benjamin Nevarez is a SQL Server MVP and independent consultant based in Los Angeles, California who specializes in SQL Server query tuning and optimization. He is the author of “SQL Server 2014 Query Tuning & Optimization”, “Inside the SQL Server Query Optimizer” and has contributed to other SQL Server books including “SQL Server 2012 Internals”. Benjamin has also been a speaker at many SQL Server conferences, including the PASS Summit, SQL Server Connections and SQLBits.

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids