This Fill Factor Quiz asks whether an index with fill factor 0 leaves more free space than one with 100. It does not: both build full pages. A tested script shows how a fill factor of 70 changes the pages and why it only applies at build time.
Nonclustered Index Rebuild Quiz: Does a Clustered Rebuild Touch Them?
This Nonclustered Index Rebuild Quiz asks what happens to the other indexes when you rebuild the clustered index. The answer is nothing, and a tested script shows it. It also covers the cases where SQL Server does rebuild them.
Indexed View Restrictions Quiz: Which Rule Blocks the Index?
This Indexed View Restrictions Quiz asks which rule stops a unique clustered index on a view. The answer is the LEFT OUTER JOIN. A tested script shows the error, the working view, and what happens when each required rule is missing.
Heap Tables: When a Table Without a Clustered Index Hurts
Find heap tables, inspect forwarded records and empty-page behavior, and choose between a clustered index and a planned rebuild.
user_lookups: Verify the Plan Before Adding Coverage
user_lookups helps identify where to investigate missing coverage. Compare complete query results and actual plans before adding included columns. Weigh the read benefit against storage and write costs.
Updating a Large Table in Batches With a Moving Key Range
Walk the clustered key a slice at a time, log each batch, and learn why stopping at the first empty batch quietly leaves rows behind.
Designing Tables for High Insert Rates
High insert rates depend on key choice, row width, index count, and retention design; learn a practical SQL Server table layout for sustained writes.