Dec 6, 2022 · The Transact-SQL programming language provides DBCC statements that act as Database Console Commands for SQL Server. Database Console Command statements are …

Dec 18, 2024 · 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.

Sep 3, 2024 · DBCC CHECKIDENT checks the current identity value for the specified table in SQL Server, and changes the value if needed.

Sep 3, 2024 · 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 …

Sep 3, 2024 · DBCC CLEANTABLE shouldn't be executed as a routine maintenance task. Instead, use DBCC CLEANTABLE after you make significant changes to variable-length …

Sep 3, 2024 · 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.

Sep 26, 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 …

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

Sep 3, 2024 · DBCC INPUTBUFFER Displays the last statement sent from a client to an instance of SQL Server.