Purpose: Use this job aid to familiarize yourself with the four categories of DBCC statements that can be used to maintain a SQL Server 2012 database.
The Transact-SQL programming language groups DBCC statements into four command categories:
informational
validation
maintenance, and
miscellaneous