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
What are different types of caching using in ASP.NET? You can use 2 types of output caching to cache information which is to be transmitted to and displayed in a Web browser:

The steps that occur when we request a ASPX page are as follows:- 1) The browser sends the request to the webserver. Now  assume that the webserver at the other end is IIS. 2

Passport authentication A centralized service given by Microsoft, offers a single logon point for clients. Unauthenticated users are redirected to the Passport site

Introduction to .NET Technology 1. Explain the following with respect to .NET Technologies: a. Web Applications b. Web Server Connections 2. Write a sample program using AS

What is the purpose of DOTNET? Dot Net Is a collection of products like C#, ASp.Net, Vb.Net, XML. The purpose of .Net is that we can simply upgrade and degrade our programs whi

Need to develop a simple .net software I am seeking someone who can design a customized software for me, prefrebly in .NET. I have a sql server backend which i would like to use

What is the main difference between Gridlayout and FlowLayout? The Grid Layout provides absolute positioning for the controls placed on the page. The Developers that have their

What is the difference between the Take and Skip clauses? The Take clause returns a specified number of elements. For instance, you can use the Take clause to return two values

I have to develop a Google Map Fix .NET Site on Android(maybe Cross Browser issue) Project Description: A developer has implemented a characteristic which involves data from

What is black box testing & White box testing? The Black box testing is also termed as functional testing. It ignores how the internal functionality of a system works & depends