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.
Relational Engine
Query Optimizer Phases
The SQL Server Query Optimizer uses cost-based optimization to create an execution plan with the least cost.