(Formerly known as Get Your Optimizer to Give up All Its Secrets)
In this presentation I discuss some of the internals of the SQL Server optimizer and demonstrate a tool that I produced to visualize query trees and memo structures and to give some optimizer statistics.
- Slide deck (PDF) (1.5 MB)
- Scripts (27 KB)
- CorpDB Database (19 MB) used by the scripts. This is a backup from SQL Server 2012. If you restore to 2014+ be sure to upgrade the compatibility level. Last updated 4 January 2017.
- SQL Server Query Tree Viewer
- SQL Saturday 523 (Iowa City, Iowa), 11 June 2016
- SQL Saturday 539 (Sioux Falls, South Dakota), 23 July 2016
- SQL Saturday 553 (Oklahoma City, Oklahoma), 26 August 2016
- SQL Saturday 548 (Kansas City, Missouri), 24 September 2016
- SQL Saturday 557 (Minneapolis, Minnesota), 1 October 2016
- SQL Saturday 552 (Lincoln, Nebraska), 19 November 2016
- SQL Saturday 604 (Madison, Wisconsin), 8 April 2017
- SQL Saturday 654 (Omaha, Nebraska), 22 July 2017
- SQL Saturday 628 (Baton Rouge, Louisiana), 29 July 2017
- SQL Saturday 631 (Wausau, Wisconsin), 16 September 2017
- SQL Saturday 719 (Chicago, Illinois), 17 Mar 2018
- SQL Saturday 700 (Colorado Springs, Colorado), 24 Mar 2018
- SQL Saturday 745 (Indianapolis, Indiana), 11 Aug 2018
- SQL Saturday 837 (Winnipeg, Manitoba), 3 Mar 2019
- SQL Saturday 869 (Phoenix, Arizona), 4 May 2019
- SQL Saturday 870 (Memphis, Tennessee), 5 Oct 2019
- SQL Saturday 943 (St. Louis, Missouri), 8 Feb 2020
- SQL Saturday 978 (Los Angeles, California – Virtual), 13 Jun 2020
- PASS Virtual Summit, 12 Nov 2020
- SQL Saturday 1034 (Denver, Colorado), 17 September 2022
Presentation History: