Inspect temp table statistics across procedure calls, compare estimates with loaded rows, and test targeted refresh and recompile fixes.
Estimated vs Actual Rows: The First Thing to Read in a Plan
Read estimated vs actual rows in execution plans, find where the first gap appears, and investigate statistics, parameters, and predicates.
SQL SERVER – SQL Server Statistics Name and Index Creation
Guest author Sandip hit Msg 1913 while creating an index, because an index or statistics with that name already existed. A lesson on statistics name and index creation.
Nonclustered Index Rebuild Quiz: Does a Clustered Rebuild Touch Them?
This Nonclustered Index Rebuild Quiz asks what happens to the other indexes when you rebuild the clustered index. The answer is nothing, and a tested script shows it. It also covers the cases where SQL Server does rebuild them.
SQL SERVER – Fix: Error: Msg 1904, Level 16 The statistics on table has 33 column names in statistics key list. The maximum limit for index or statistics key column list is 32
Statistics can use up to 32 columns, while an index key is limited to 16. Here is Msg 1904 with a quick demo of 33 versus 32 columns.
Temp Table Caching: Why Some Temp Tables Get Reused
Understand temp table caching in stored procedures, avoid cache blockers, inspect creation counters, and review retained statistics.
SQL Statistics: How SQL Server Estimates Row Counts
SQL statistics are small summaries of your data that tell the optimizer how many rows a query will return. This post builds an orders table with one rare value and one common value, reads the histogram, compares estimated and actual rows in the plans, and shows a stale statistic fixed with UPDATE STATISTICS. Every result comes from SQL Server 2025.