SQL Server DBCC maintenance commands


DBCC CHECKDB

Checks integrity of all tables in the database.

DBCC CHECKTABLE

Checks integrity of the table.

DBCC CHECKTABLE ("HumanResources.Employee")

Options include:

DBCC CHECKTABLE ("HumanResources.Employee") WITH PHYSICAL_ONLY - low overhread check recommended for large tables

DBCC CHECKTABLE ("HumanResources.Employee") WITH TABLOCK - table becomes read-only while command is being run