It’s a common question of DBA interview. I already have faced millions of time. HaHa Ha. DBCC is a series of statements in Transact-SQL programming language to check the physical and logical consistency of SQL Server database. We can divide in 4 major category or type…

DBCC command type…

1.    Informational DBCC command

2.       Validational DBCC command

3.       Maintenance DBCC command

4.       Miscellaneous DBCC command

1.       Informational DBCC commands

·         DBCC INPUTBUFFER              

·         DBCC SHOWCONTIG

·         DBCC OPENTRAN

·         DBCC SQLPERF

·         DBCC OUTPUTBUFFER

·         DBCC TRACESTATUS

·         DBCC PROCCACHE

·         DBCC USEROPTIONS

·         DBCC SHOW_STATISTICS

2.       Validation DBCC commands

·         DBCC CHECKALLOC

·         DBCC CHECKFILEGROUP

·         DBCC CHECKCATALOG

·         DBCC CHECKIDENT

·         DBCC CHECKCONSTRAINTS

·         DBCC CHECKTABLE

·         DBCC CHECKDB

3.       Maintenance DBCC commands

·         DBCC CLEANTABLE

·         DBCC INDEXDEFRAG

·         DBCC DBREINDEX

·         DBCC SHRINKDATABASE

·         DBCC DROPCLEANBUFFERS

·         DBCC SHRINKFILE

·         DBCC FREEPROCCACHE

·         DBCC UPDATEUSAGE

4.       Miscellaneous DBCC commands

·         DBCC dllname (FREE)

·         DBCC HELP

·         DBCC FLUSHAUTHCACHE

·         DBCC FREESESSIONCACHE

·         DBCC FREESYSTEMCACHE

·         DBCC TRACEOFF

·         DBCC TRACEON

·         DBCC IND

·         DBCC PAGE

             Stay Tuned!!!!!

–By Abhishek….