SQL Server DBA

Routine maintenance, integrity checks, and capacity management

Question

DBCC CHECKDB versus DBCC CHECKTABLE: what differs, and when should each run?

Answer

CHECKDB validates allocation, structural, and logical integrity for the whole database. CHECKTABLE validates one table or indexed view and its indexes. Run CHECKDB on the full maintenance cadence; use CHECKTABLE for focused investigation or very large-database coverage.

This is 12 of 25 free samples for SQL Server DBA.

More SQL Server DBA topic samples