As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

Posted by

To view Verified answers click on the button below.

DBCC CHECKDB, DBCC CHECKTABLE, DBCC CHECKCATALOG, DBCC CHECKALLOC, DBCC
SHOWCONTIG, DBCC SHRINKDATABASE, DBCC SHRINKFILE etc. But there are a whole
load of DBCC commands which are very useful for DBAs. Check out SQL Server books
online for more information.