Maintenance statement
DBCC DBREINDEX Rebuild One or more index DBCC DBREPAIRs in the specified database Remove corrupted database DBCC indexdefrag to organize the specified table or view aggregation index and the auxiliary index DBCC ShrinkDatabase shrink the data file size in the specified database DBCC SHRINKFILE contraction related database Specify data files or log file size DBCC UpdateUsage reports and correct the incorrect content of the SysIndexes table, which may cause incorrect space use reports via the sp_spaceused system stored procedure
Status Statement DBCC InputBuffer Displays the last statement from the client to MS SQL Server DBCC OpenTran If there is the oldest activity transaction and the oldest distribution and non-distributed replication transactions in the specified database, the information is displayed. The result is only displayed when there is an active transaction or database contains replication information. If there is no active transaction, displaying the information message DBCC OutputBuffer Returns the current output buffer DBCC Proccache of the specified system process ID (SPID) in hexadecimal or ASCII format DBCC Proccache to display the information of the process cache for the report. DBCC ShowContig display specified Table data and indexed fragmentation information DBCC Show_statistics Display the current distribution statistics of the specified target on the specified table DBCC SQLPERF provides statistics about transaction log space in all databases DBCC TraceStatus Display Tracking Mark Status DBCC UserOptions Returns the current connection SET options for activities (settings)
Verify statement DBCC Checkalloc Checks the consistency of the disk space allocation structure of the specified database DBCC CheckCatalog Check the consistent DBCC CHECKCONSTRAINTS in the specified database DBCC CHECKCONSTRAINTS Check the specified constraint or all constraints of integrity DBCC CHECKDB Check Specify all objects of all objects in the database DBCC checkfilegroup Check all tables in the specified file group (in the current database) allocation and structural integrity DBCC CHECKIDENT checks the current identifier value of the specified table, if necessary, Laido value correction
DBCC CheckTable Checks the data, index and text, ntext, ntext, ntext, ntext, ntext, and image pages of the specified table or index view, DBCC NEWALLOC Check the data and index page of each table within the extended structure of the database.
