Why is OUTER JOIN not allowed in indexed views? A reader was confused by the white paper answer, so I explain it with an example and ask for yours.
SQL SERVER – Disabled Index and Update Statistics
A reader asked how disabled indexes affect statistics. With the clustered index disabled, Update Statistics throws an error; see what happens once you enable it.
SQL SERVER – Update Statistics are Sampled By Default
A reader asked if statistics are sampled by default. They are, and a one million row test table proves it. You can set the rate up to 100%.
SQL SERVER – When Are Statistics Updated – What Triggers Statistics to Update
When are statistics updated in SQL Server, and what triggers it? I compared the algorithms in many documents and share the most common rule. Tell me if it holds.
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 – Enable Automatic Statistic Update on Database
Good indexes and a tuned query still ran slow because auto update of statistics was off. Enable Automatic Statistic creation and update, then update all stats.
SQL SERVER – SQL Server Management Studio and Client Statistics
Query cost does not tell you how much data a query returns. Client statistics in SQL Server Management Studio do, and there are three ways to turn them on.