DBCC DBREINDEX still runs on SQL Server 2025, but it is deprecated, and ALTER INDEX does everything it did and more. This post rebuilds a fragmented demo table both ways, shows the options only ALTER INDEX has, and finds old uses of DBCC DBREINDEX in your own modules, Agent jobs and the deprecation counter.
Unique Index Performance: What a UNIQUE Index Saves
Unique index performance gains come from what the optimizer learns, not from smaller pages. A tested demo compares pages, reads, plans and CPU for a plain index and a unique index. It also shows the error a duplicate causes.
Coffee Mug – Indexes and SELECT Queries
Sometimes I feel like I have become a kid again. This morning I received a coffee mug with printed quotes of Indexes and SELECT Queries.
SQL SERVER – 3 Questions: An Index Reduces Performance of SELECT Queries
An index can reduce the Performance of SELECT Queries when it changes a particular plan unfavorably. Readers asked three follow-up questions.
Index Slows Down SELECT? What an Unused Index Costs You
An index slows down SELECT queries only in small ways when the plan never reads it. This post measures compile memory with twelve unused indexes, shows the plan change when a related index appears, and counts what every insert and update pays. The real bill arrives on writes.
When was Table Accessed Last By User? – Interview Question of the Week #226
When was a table accessed last by a user? When clients say a table is rarely used, I run this report to check before we create or drop indexes.
Columnstore Deleted Rows: When the Delete Bitmap Slows Scans
Inspect columnstore deleted rows, measure delete-bitmap overhead, and choose targeted REORGANIZE work before a heavier rebuild.