Partition Pruning Defeated by a Function

Diagnosing a Skewed Hash Join at Scale

Data Skew and Join Strategy at Scale

Execution Plans & Optimization at Scale

Non-SARGable Predicate Kills Index

Diagnosing Slow Plans at Scale

Execution Plans at Scale

Execution Plans at Scale

LEFT JOIN Silently Becomes INNER JOIN

Join Order and Cardinality Estimation

Non-Sargable Predicate Kills Index Usage

Estimated vs Actual Row Counts

CTE Materialization and Optimization Fences

CTE Materialization vs Inlining

Complex Joins, CTEs & Perf Reasoning

Query Performance & Execution Plans

Reading a Query Execution Plan

Indexes and Execution Plans