Presentation: 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.