Recompile Archives - Page 2 of 2 - SQL Authority with Pinal Dave

Cyclists riding in single file behind a leader in a vermilion jersey who breaks the wind for them.

OPTIMIZED_SP_EXECUTESQL in SQL Server 2025: Fewer Compile Storms

July 3, 2013

Dynamic SQL, Recompile, SQL Cache, SQL Server

Test OPTIMIZED_SP_EXECUTESQL in SQL Server 2025, inspect compilation counters and cached plans, and compare a concurrent workload.

A hand-drawn map where a road has been redrawn in red around a new lake

Why Queries Recompile

March 24, 2013

Pinal Dave

SQL Performance

Execution Plan, Recompile, SQL Cache, SQL Extended Events, SQL Performance

Why queries recompile becomes clearer when you capture Extended Events causes and check schema changes, statistics, SET options, and temp tables.

A plain map spread on a wooden table with a red ribbon marking a new detour route, a brass compass beside it.

Stored Procedure Recompile Quiz: What Forces a New Plan?

January 15, 2012

Pinal Dave

SQL Puzzle

Execution Plan, Parameter Sniffing, Recompile, SQL Stored Procedure

This Stored Procedure Recompile Quiz asks which action makes SQL Server build a new plan for a procedure. The answer is a new index on a table it reads. A tested script uses plan counters to show what reuses the plan and what rebuilds it.

A cobbler's bench with a worn standard shoe last and a freshly carved custom last among wood shavings.

OPTIMIZE FOR and RECOMPILE Hints Compared

July 22, 2010

Pinal Dave

SQL Performance

Execution Plan, Parameter Sniffing, Query Hint, Recompile, SQL Server

OPTIMIZE FOR and RECOMPILE address parameter-sensitive plans differently; compare stable representative values with per-run compilation cost.