John Deardurff

The SQL Server Database Engine

The three parts of the SQL Server database engine with a focus on how the SQL Server Operating System (SQLOS) component manages resources.

SQL Query Processing

How SQL Queries are processed by the Relational Engine. Parsing, Resolving, Optimizing, Compiling, and Executing to return SQL Sets.

Query Optimizer Phases

The SQL Server Query Optimizer uses cost-based optimization to create an execution plan with the least cost.