Understand local variable estimates with skewed data, density calculations, parameter comparisons, and targeted OPTION RECOMPILE tests.
SQL SERVER – FIX: Arithmetic Overflow Error in Object Execution Statistics Report in Management Studio
The SSMS Object Execution Statistics report suddenly failed for a client with Msg 8115, arithmetic overflow converting to int. Here is why and what to do.
How to Drop All the User Created Statistics by SQL Server? – Interview Question of the Week #158
SQL Server creates statistics on its own, but DBAs and the Tuning Advisor add more. Here is a script to drop all user Created Statistics safely.
How Readable Secondary Replicas Build Their Own Statistics
Learn why readable secondary replicas create temporary statistics in tempdb, how to find them, and when the primary needs a permanent statistic.
Querying a Histogram With sys.dm_db_stats_histogram Instead of DBCC
Query sys.dm_db_stats_histogram to inspect statistics steps, compare stored estimates with data, and identify values beyond the last step.
Auto-Created Statistics: What the _WA_Sys Names Tell You
Read auto-created statistics through sys.stats and sys.stats_columns, then use their columns as clues for better query tuning.
Parse and Compile Time: Reading the First Line of STATISTICS TIME
Someone pastes a compile time of 24 ms and asks if the server is slow. Run it twice and watch the plan cache do its job.