SQL SERVER – Fix: Error: Msg 1904 The statistics on table has 65 columns in the key list. Let us learn how to fix in this blog.
How to Find Outdated Statistics? – Interview Question of the Week #081
How do you find outdated statistics? The honest answer is that ‘outdated’ is subjective. I explain why, and how I look at statistics instead.
SQL SERVER – The NOLOCK Question – Notes from the Field #117
Stuart Ainsworth discusses NOLOCK, dirty reads and safer alternatives. A two-session example shows why uncommitted results can be misleading.
SQL SERVER – Three Simple Guidelines for System Maintenance – Notes from the Field #098
Notes from the Field #098: three simple guidelines for system maintenance. Automate what you can, document the rest, and always validate.
SQL SERVER – Basic Statistics Maintenance – Notes from the Field #083
Statistics help the SQL Server engine pick an optimal plan. This Notes from the Field episode covers the basics of statistics maintenance every DBA should know.
SQL SERVER – Reading Statistics IO Data
I start every tuning exercise with Statistics IO. Here is how to read its output: scan count, logical reads, physical reads and read-ahead reads per table.
SQL SERVER – What is Filtered Statistics?
Filtered statistics, added in SQL Server 2008, help the optimizer estimate rows when data is correlated. Here is a small demo with Employee and Sales tables.