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.
John Deardurff
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.