What is the Use of DBCC Commands in SQL Server ?

The Transact-SQL programming language provides DBCC statements that act as Database Console Commands for SQL Server. DBCC commands are used to perform the following tasks.

  • Maintenance tasks on database, index, or filegroup.
  • Tasks that gather and display various types of information.
  • Validation operations on a database, table, index, catalog, filegroup, or allocation of database pages.
  • Miscellaneous tasks such as enabling trace flags or removing a DLL from memory.


You May Interest

What is a Covered Index in SQL Server ?

Listing Metadata of MS SQL Server Internal Tables

What is the Difference Between VARCHAR and NVARCHAR in SQL Server ...

Making a MS SQL Database Offline

What is the Difference Between CHAR and VARCHAR Datatypes in SQL ...