O'Reilly logo

SQL Server 2008: Administration in Action by Rod Colledge

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

12.1. DBCC validation overview

Table 12.1 shows the full set of DBCC commands by category. Note that there are a number of undocumented commands not found in this list, such as DBCC PAGE, which we'll cover later in the chapter.

Table 12.1. DBCC commands by category 
DBCC categoryDBCC statement
InformationalDBCC INPUTBUFFER
 DBCC SHOWCONTIG
 DBCC OPENTRAN
 DBCC SQLPERF
 DBCC OUTPUTBUFFER
 DBCC TRACESTATUS
 DBCC PROCCACHE
 DBCC USEROPTIONS
 DBCC SHOW_STATISTICS
ValidationDBCC CHECKALLOC
 DBCC CHECKFILEGROUP
 DBCC CHECKCATALOG
 DBCC CHECKIDENT
 DBCC CHECKDB
MaintenanceDBCC CLEANTABLE
 DBCC INDEXDEFRAG
 DBCC DBREINDEX
 DBCC SHRINKDATABASE
 DBCC DROPCLEANBUFFERS
 DBCC SHRINKFILE
 DBCC FREEPROCCACHE
 DBCC UPDATEUSAGE
MiscellaneousDBCC DLLNAME
 DBCC HELP
 DBCC TRACEON
 DBCC ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required