Database consistency checker commands (dbcc), DOT NET Programming

What is DBCC?

The Database Consistency Checker Commands (DBCC) is used to check the logical and physical consistency of the database structure.The DBCC statements can fix and detect the problems.They are grouped into 4 categories as shown below :-

1)The Maintenance commands such as DBCC DBREPAR, DBCC DBREINDEX  etc , they are mostly used for the maintenance tasks in SQL SERVER.

2)The Miscellaneous commands such as DBCC TRACEO, DBCC ROWLOCK  etc , they are mostly used for enabling the row-level locking or removing DLL from the memory.

3)he Status Commands such as the DBCC SHOWCONTIG , DBCC OPENTRAN etc , they are mostly used for checking the status of the database.

4)The Validation Commands such as DBCC CHECKCATALOG, DBCC CHECKALLOCetc , they perform validation operations on the database.

The sample screen is shown below in which the DBCC SHOWCONTIG command is run.The DBCC SHOWCONTIG is used to display the fragmentation information for the data and indexes of the specified table.In the sample screen the "Customer" table is checked for the fragmentation information. If you see at the figure the "Scan density" is 100 if everything is ucontigious in this image it is 95.36% that is a decent percentage. So such type of useful information can be collected by the DBCC command and database performance and the maintenance can be improved.

1113_DBCC.png

Figure :-DBCC SHOWCONTIG command in action.

Posted Date: 9/24/2012 3:30:00 AM | Location : United States







Related Discussions:- Database consistency checker commands (dbcc), Assignment Help, Ask Question on Database consistency checker commands (dbcc), Get Answer, Expert's Help, Database consistency checker commands (dbcc) Discussions

Write discussion on Database consistency checker commands (dbcc)
Your posts are moderated
Related Questions
ASP Programmer I need a fixing all W3c validation errors and it is a ASP website. Have any queries please send a message and I will provide more information on project. De

What are the improvements made in CAS in .NET 4.0? The CAS mechanism in .NET is used to control and configure the ability of managed code. Previously, as this policy was applic

I need Game development tutorials Project Description: We need video tutorials like lynda for game development using unity. You must have developed games before and need to s

What is Multi-threading? Multi-threading process forms the subset of Multi-tasking. Inspite of having to switch between programs this feature switches between different parts o

i would like to learnd API''s how they works for advance programming in vb.net

A Super-hero SharePoint developer with great design skills Project Description: US: Our start-up company prepares a very innovative and cool SharePoint related product with c

Work on different coding using visual studio 2012/2013 writing Java script as well as C# codes. Project Description: I want to shift to new Programming Env. and I would like

What are types of compatibility in VB6 There are three possible project compatibility settings: No Compatibility Project Compatibility Binary Compatibility

Project Description: Simple task and requirements to be done professionally. Propose an Object Oriented design and show drawback. .NET, C Programming, Business Analysis, P

What is Dispose method in .NET? The .NET provides "Finalize" method in which we can clean up our resources. But relying on this is not always better so the best is to implement