Sunday, January 24, 2010

DBCC Commands By Category

Informational:
DBCC INPUTBUFFER 
DBCC SHOWCONTIG 
DBCC OPENTRAN 
DBCC SQLPERF 
DBCC OUTPUTBUFFER 
DBCC TRACESTATUS 
DBCC PROCCACHE 
DBCC USEROPTIONS 
DBCC SHOW_STATISTICS
 
Validation:
DBCC CHECKALLOC

DBCC CHECKFILEGROUP

DBCC CHECKCATALOG

DBCC CHECKIDENT

DBCC CHECKDB

Maintenance:
DBCC CLEANTABLE 
DBCC INDEXDEFRAG
DBCC DBREINDEX 
DBCC SHRINKDATABASE 
DBCC DROPCLEANBUFFERS 
DBCC SHRINKFILE 
DBCC FREEPROCCACHE 
DBCC UPDATEUSAGE

Miscellaneous: 
DBCC DLLNAME
DBCC HELP
DBCC TRACEON
DBCC TRACEOFF
sql server dba dbcc commands. all dbcc commands list. sql server 2012 dbcc commands. all dbcc list. sql server 2008 r2 dbcc commands. sql server 2005 dbcc commands. sql server dbcc help. dbcc. dbcc usage. new dbcc commands. dbcc list. dbcc category.

0 comments:

Post a Comment