Relational Engine

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.


Query Optimizer Phases

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