• I find the report of DBCC CHECKDB useful.

    Why doesn't "SELECT COUNT(*) FROM table" look at an index, which apparently it doesn't(?)