John Deardurff



Query Optimizer Phases

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





SQL Query Processing

Understand SQL Query Processing and how SQL Server parses and binds queries, ensuring syntax accuracy and resolving object names.


Writing T-SQL Queries

In late 2018, I recorded a series of videos for APRESS publishing on how to write T-SQL Queries. (I have linked to the O’Reilly website below.) There are four titles in the series with each title about 45 minutes in length. The first is how to write a T-SQL SELECT…