Find foreign keys without indexes, inspect parent-delete plans, and choose leading child-table keys that support relationship checks.
Missing Index Query Text: Linking Suggestions to Their Queries
A missing index suggestion means more when you can see its query. Here is how to link them, trim the text and test the index.
Change Fill Factor in SQL Server: SQL in Sixty Seconds #069
To change fill factor for an index, rebuild it with a new FILLFACTOR value. The tests here measure what 100, 80 and 50 do to page count, scan reads and page splits, and when a lower value is not worth the space.
Explain a SQL Server Index in Sixty Seconds, Then Prove It
How to explain a SQL Server index in an interview in about a minute, then prove every word with one table. On SQL Server 2025, the same query read 5,737 pages with no index, 133 with a plain index and 3 with a covering index. Three extra indexes doubled the log of 20,000 inserts.
Index Usage Stats Reset: Reading Them Without Being Fooled
Use index usage stats reset in SQL Server with practical examples, clear checks, and the limits you need before changing your database.
Resumable Index Rebuilds: Pausing Maintenance Without Losing Progress
Run a resumable index rebuild with ONLINE and MAX_DURATION, pause and resume it, inspect progress, and weigh edition and log costs.
Moving a Table to Another Filegroup by Rebuilding Its Clustered Index
One statement moves the rows, but large-object data and other indexes stay behind. A small demo shows exactly where everything ends up.