Tag: plan cache

SQL Server insights from 25+ years in the field

Performance tips, security advisories, health check findings, and industry analysis. Practical, technically accurate, no fluff.

15 May 2018 · 6 min read

Script: Query Full Table Scans via the Search Cached Plans’ DMV

Use SQL Server's plan cache DMVs to surface full table scans, missing indexes, and columns with no statistics without running a trace or waiting for an incident.

Read article →
15 May 2018 · 5 min read

Recompile All SQL Server Stored Procedures with this Script

Recompile all stored procedures in a SQL Server database with a single script. Refresh stale execution plans after schema or statistics changes without dropping any objects.

Read article →

SQL Server insights, monthly.

Performance tips, security advisories, and industry analysis. No fluff, no spam.