Nov 18, 2025 · The Transact-SQL programming language provides DBCC statements that act as Database Console Commands for SQL Server. Database Console Command statements are …

DBCC CHECKDB checks the logical and physical integrity of all the objects in the specified database.

Sep 3, 2024 · DBCC CHECKTABLE checks the integrity of all the pages and structures that make up the table or indexed view.

Nov 18, 2025 · DBCC CHECKIDENT checks the current identity value for the specified table in SQL Server, and changes the value if needed.

Nov 18, 2025 · Executing DBCC FREEPROCCACHE in a user database clears the plan cache for that database. If the database is in an elastic pool, it also clears the plan cache in all other databases in …

Nov 18, 2025 · DBCC CLEANTABLE shouldn't be executed as a routine maintenance task. Instead, use DBCC CLEANTABLE after you make significant changes to variable-length columns in a table or …

DBCC CLONEDATABASE creates a schema-only copy of a database that includes all the elements necessary to troubleshoot query performance issues without copying the data.

6 days ago · SQL Server requires VIEW SERVER STATE permission on the server to run DBCC SQLPERF(LOGSPACE). To reset wait and latch statistics requires ALTER SERVER STATE …

Nov 18, 2025 · DBCC SHOW_STATISTICS displays the header, histogram, and density vector based on data stored in the statistics object. The syntax lets you specify a table or indexed view along with …

Sep 3, 2024 · In Azure SQL Database, DBCC DROPCLEANBUFFERS acts on the database engine instance hosting the current database or elastic pool. Executing DBCC DROPCLEANBUFFERS in a …