{"id":234,"date":"2012-05-29T10:22:26","date_gmt":"2012-05-29T10:22:26","guid":{"rendered":"https:\/\/sqlserverlearner.azurewebsites.net\/2012\/05\/29\/list-of-dbcc-commands-in-sql-server\/"},"modified":"2012-05-29T10:22:26","modified_gmt":"2012-05-29T10:22:26","slug":"list-of-dbcc-commands-in-sql-server","status":"publish","type":"post","link":"https:\/\/sqlserverlearner.com\/2012\/05\/29\/list-of-dbcc-commands-in-sql-server\/","title":{"rendered":"list of dbcc commands in sql server"},"content":{"rendered":"<p><strong>Following are the list of dbcc commands in sql server 2012<\/strong><br \/>\nDBCC CHECKALLOC<br \/>\nDBCC CHECKDB<br \/>\nDBCC CHECKCATALOG<br \/>\nDBCC CHECKFILEGROUP<br \/>\nDBCC CHECKTABLE<br \/>\nDBCC TABLE CHECK<br \/>\nDBCC TABLE REPAIR<br \/>\nDBCC ALLOC CHECK<br \/>\nDBCC ALLOC REPAIR<br \/>\nDBCC SYS CHECK<br \/>\nDBCC SYS REPAIR<br \/>\nDBCC SSB CHECK<br \/>\nDBCC CHECKCATALOG<br \/>\nDBCC IVIEW CHECK<br \/>\nDBCC INPUTBUFFER<br \/>\nDBCC SHOWCONTIG<br \/>\nDBCC OPENTRAN<br \/>\nDBCC SQLPERF<br \/>\nDBCC OUTPUTBUFFER<br \/>\nDBCC TRACESTATUS<br \/>\nDBCC PROCCACHE<br \/>\nDBCC USEROPTIONS<br \/>\nDBCC SHOW_STATISTICS<br \/>\nDBCC CHECKALLOC<br \/>\nDBCC CHECKFILEGROUP<br \/>\nDBCC CHECKCATALOG<br \/>\nDBCC CHECKIDENT<br \/>\nDBCC CHECKCONSTRAINTS<br \/>\nDBCC CHECKTABLE<br \/>\nDBCC CHECKDB<br \/>\nDBCC CLEANTABLE<br \/>\nDBCC INDEXDEFRAG<br \/>\nDBCC DBREINDEX<br \/>\nDBCC SHRINKDATABASE<br \/>\nDBCC DROPCLEANBUFFERS<br \/>\nDBCC SHRINKFILE<br \/>\nDBCC FREEPROCCACHE<br \/>\nDBCC UPDATEUSAGE<br \/>\nDBCC dllname<br \/>\nDBCC HELP<br \/>\nDBCC FREESESSIONCACHE<br \/>\nDBCC TRACEOFF<br \/>\nDBCC FREESYSTEMCACHE<br \/>\nDBCC TRACEON<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Following are the list of dbcc commands in sql server 2012 DBCC CHECKALLOC DBCC CHECKDB DBCC CHECKCATALOG DBCC CHECKFILEGROUP DBCC CHECKTABLE DBCC TABLE CHECK DBCC TABLE REPAIR DBCC ALLOC CHECK DBCC ALLOC REPAIR DBCC SYS CHECK DBCC SYS REPAIR DBCC SSB CHECK DBCC CHECKCATALOG DBCC IVIEW CHECK DBCC INPUTBUFFER DBCC SHOWCONTIG DBCC OPENTRAN DBCC SQLPERF&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2064],"tags":[2065,2066],"_links":{"self":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts\/234"}],"collection":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/comments?post=234"}],"version-history":[{"count":0,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts\/234\/revisions"}],"wp:attachment":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/media?parent=234"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/categories?post=234"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/tags?post=234"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}