Plan recompilation hurts performance just like a first compile. Learn what causes it, from schema changes to SET options, and how to reduce recompilation.
Stored Procedure Optimization Tips That Still Matter
Stored Procedure Optimization comes down to a short list of habits you can test on your own server. This post builds one badly written procedure and one good one on a small orders table, then measures the difference in logical reads. It also covers parameter sniffing, the sp_ prefix, short transactions and error handling.
Report Caching and Snapshots in SSRS
Report caching and snapshots in SSRS reduce repeated database work when freshness rules, parameter combinations, and schedules are clear.
The First Hour on a Server Nobody Can Explain
Investigate a slow SQL Server in a fixed order, checking connectivity, blocking, waits, plans, and storage before changing the environment.
SQL SERVER – Find Statistics Update Date – Update Statistics
Stale statistics can hurt a query plan. Use STATS_DATE to find the statistics update date for each index, then update them if they look outdated.
SQL SERVER – Execution Plan – Estimated I/O Cost – Estimated CPU Cost – No Unit
What is estimated I/O cost, what is estimated CPU cost, and why do these costs in an execution plan have no unit? I answer these common training questions.
SQL SERVER – Find Busiest Database
How do you find the busiest database on a SQL Server instance? I use sys.dm_exec_query_stats to add up logical reads and writes for each database.