When using SQL Server, you will need access to Database Console Commands, and this is exposed to the Database Administrator using DBCC commands. SQL Server Database Console Command statements are grouped into the following categories.
|Maintenance||Maintenance tasks on a database, index, or filegroup.|
|Miscellaneous||Miscellaneous tasks such as enabling trace flags or removing a DLL from memory.|
|Informational||Tasks that gather and display various types of information.|
|Validation||Validation operations on a database, table, index, catalog, filegroup, or allocation of database pages.|
DBCC commands take input parameters and return values.
These commands will create a read-only database snapshot. While this helps prevent concurrency and blocking issues, but it can cause issues with free drive space.
DBCC CHECKDB fails when it is run against master if an internal database snapshot cannot be created.
To get basic information about the DBCC command available, see this blog post.