Evaluate indexed views by building a sales summary, comparing read savings with write maintenance, and using NOEXPAND where required.
Puzzle – Usage of New Index Hints – ForceSeek and ForceScan
SQL Server Denali adds the FORCESCAN hint next to FORCESEEK. A weekend puzzle on these Index Hints: write a query where each one improves performance.
What Lock Escalation Is and How to Stop It
Understand lock escalation, confirm it with evidence, and reduce its impact through smaller transactions, better access paths, and modern locking.
SQL SERVER – Query to Find Duplicate Indexes – Script to Find Redundant Indexes
Duplicate indexes are pure overhead on every insert, update and delete. Here is my script to find duplicate and overlapping indexes so you can review them.
Interview Questions and Answers – Frequently Asked Questions Day 6 of 31
Frequently Asked Questions Day 6: which TCP/IP port SQL Server runs on and how to change it, and the difference between a clustered and a non-clustered index.
SQL SERVER – Solution – Puzzle – Statistics are not Updated but are Created Once
The solution to my puzzle on why statistics are not updated but are created once after a large insert, even with auto update on, and the fix that worked for me.
Too Many Indexes on One Table
Too many indexes on a SQL Server table can slow every write; learn how to identify overlapping indexes, measure their value, and remove them safely.