Skip to main content

DBCC Command (Database Consistency Checker) -Sql Server

Database Consistency Checker act as Database Console Commands give details in form of statistics about the SQL Server. They can be used for Maintenance of database, index, or file group. DBCC Commands can be used to perform validation operations on a database, table, index, catalog, file group, or allocation of database pages.
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 Internal Database Snapshot command 

 
DBCC CHECKALLOC 
DBCC CHECKDB
DBCC CHECKCATALOG 
DBCC CHECKFILEGROUP
DBCC CHECKTABLE

Progress Reporting for DBCC Commands

 
DBCC TABLE CHECK 
DBCC TABLE REPAIR
DBCC ALLOC CHECK
DBCC CHECKALLOC
DBCC ALLOC REPAIR
DBCC SYS CHECK   
DBCC SYS REPAIR  
DBCC SSB CHECK   
DBCC CHECKCATALOG
DBCC IVIEW CHECK

Miscellaneous command

DBCC dllname (FREE)    
DBCC HELP
DBCC FLUSHAUTHCACHE    
DBCC TRACEOFF
DBCC FREESESSIONCACHE  
DBCC TRACEON
DBCC FREESYSTEMCACHE   
DBCC CLONEDATABASE

Maintenance Statements

DBCC CLEANTABLE  
DBCC INDEXDEFRAG
DBCC DBREINDEX   
DBCC SHRINKDATABASE
DBCC DROPCLEANBUFFERS  
DBCC SHRINKFILE
DBCC FREEPROCCACHE     
DBCC UPDATEUSAGE

Validation Statements

 
DBCC CHECKALLOC  
DBCC CHECKFILEGROUP
DBCC CHECKCATALOG
DBCC CHECKIDENT
DBCC CHECKCONSTRAINTS  
DBCC CHECKTABLE
DBCC CHECKDB


Informational Statements

 
DBCC INPUTBUFFER 
DBCC SHOWCONTIG
DBCC OPENTRAN    
DBCC SQLPERF
DBCC OUTPUTBUFFER
DBCC TRACESTATUS
DBCC PROCCACHE   
DBCC USEROPTIONS
DBCC SHOW_STATISTICS
Labels:

Comments

Post a Comment

Popular posts from this blog

What is RDBMS?

In our crucial programming world, RDBMS is stand for Relational Database Management Systems is based on the Relational Model that maintain data records and index in tables. Generally, the term "Relations" are maintained in RDMS.  In a relational database,store the data into collection of tables, which might be related by common fields (database table columns). RDBMS also provide relational operators to manipulate the data stored into the database tables. Most RDBMS use SQL as database query language. There are several objects are included in RDBMS like ,Indexes,Synonyms,Tables,Views Clusters,Constraints,Database links,Database triggers. Most popular RDBMS  are Oracle, MS-SqlServer, MySql,DB2. etc.
Post a Comment
Read more

What are the difference between DDL, DML , DCL and TCL commands?

Database Command Types DDL Data Definition Language  (DDL) statements are used to define the database structure or schema.  -           CREATE - to create objects in the database -           ALTER - alters the structure of the database -           DROP - delete objects from the database -           TRUNCATE - remove all records from a table, including all spaces allocated for the records are removed -           COMMENT - add comments to the data dictionary -           RENAME - rename an object DML Data Manipulation Language  (DML) statements are used for managing data in database. DML commands are not auto-committed. It means changes made by DML command are not permanent to d...
2 comments
Read more

Identify and Delete duplicate Records in SQL Server

      S cenario: I have accumulated data into SQL Server database from three different servers (oracle, O2 and oracle) for a financial reporting. After data accumulated , we found more duplicate rows; business requirement was to remove all duplicate rows because of final data will be import to another system. For this purpose, I want to write script to find out duplicate rows from my table. Finally, I want to delete only duplicate rows not original row. Original row means if i have total 2 rows those same or duplicate, so I want to delete only one row that is duplicate. Let’s go............................ Step 1: Create a student Table below Script: CREATE TABLE [Students] (     [ID] [int] NULL,     [Name] [varchar] ( 50 ) NULL,     [address] [varchar] ( 50 ) NULL,     [contact] [varchar] ( 50 ) NULL,     [email] [varchar] ( 50 ) NULL ...
1 comment
Read more