:::: MENU ::::

T-SQL Database Console Command statements

DBCC Commands, dbDigger

T-SQL Database Console Command statements

DBCC
The Transact-SQL programming language provides DBCC statements that act as Database Console Commands for Microsoft SQL Server. These statements check the physical and logical consistency of a database. Many DBCC statements can fix detected problems.
Database Console Command statements are grouped into these categories.
Maintenance Statements:
  • DBCC DBREINDEX
  • DBCC DBREPAIR
  • DBCC INDEXDEFRAG
  • DBCC SHRINKDATABASE
  • DBCC SHRINKFILE
  • DBCC UPDATEUSAGE
Miscellaneous Statements:
  • DBCC dllname (FREE)
  • DBCC HELP
  • DBCC PINTABLE
  • DBCC ROWLOCK
  • DBCC TRACEOFF
  • DBCC TRACEON
  • DBCC UNPINTABLE
Status Statements:
  • DBCC INPUTBUFFER
  • DBCC OPENTRAN
  • DBCC OUTPUTBUFFER
  • DBCC PROCCACHE
  • DBCC SHOWCONTIG
  • DBCC SHOW_STATISTICS
  • DBCC SQLPERF
  • DBCC TRACESTATUS
  • DBCC USEROPTIONS
Validation Statements:
  • DBCC CHECKALLOC
  • DBCC CHECKCATALOG
  • DBCC CHECKCONSTRAINTS
  • DBCC CHECKDB
  • DBCC CHECKFILEGROUP
  • DBCC CHECKIDENT
  • DBCC CHECKTABLE
  • DBCC NEWALLOC
Consult us to explore the Databases. Contact us