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.
Indexing Foreign Keys
Indexing foreign keys can speed joins and parent deletes when child-side indexes are missing; learn how to find gaps and test write tradeoffs.
SQL SERVER – Understanding ALTER INDEX ALL REBUILD with Disabled Clustered Index
What does ALTER INDEX ALL REBUILD do when the clustered index is disabled, compared to rebuilding just that index? A step by step demo shows it.
SQL SERVER – Size of Index Table for Each Index – Solution 3 – Powershell Index Size
Laerte Junior fixed my Powershell setup remotely in minutes and sent solution 3 to my puzzle on the size of each index. Here is his Powershell Index Size answer.
SQL SERVER – Size of Index Table for Each Index – Solution 2
A second solution to my size of index table puzzle: Rama Mathanmohan’s query sums used pages from sys.allocation_units to give each index size in KB.
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%.