Database consistency checker commands (dbcc), DOT NET Programming

Assignment Help:

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.


Related Discussions:- Database consistency checker commands (dbcc)

Very very boards, Very, Very Boards does a big business in shirts, especial...

Very, Very Boards does a big business in shirts, especially for groups and teams. They need a project that will calculate the price for individual orders, as well as a summary for

Write the basic syntax of a linq query in visual basic, Write the basic syn...

Write the basic syntax of a LINQ query in Visual Basic as well as in C#. In Visual Basic, the basic syntax of a LINQ query begins with the from clause and ends with the Select

Work with me on different coding using visual studio, Work on different cod...

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 is the use of a .disco file, What is the use of a .disco file? A c...

What is the use of a .disco file? A client application uses a .disco file to locate or discover the documents that have the description of a Web service. The .disco file having

Are you available to discuss about my project, Are you available to discuss...

Are you available to discuss about my project. I'd like you to show first and then accept the project provided if we both agree to continue with each other. Skills required:

Yuy, Ask queyuyuystion #Minimum 100 words accepted#

Ask queyuyuystion #Minimum 100 words accepted#

Define an event, Define an event. Whenever an action takes place in a c...

Define an event. Whenever an action takes place in a class, that class gives a notification to other classes or objects that are assigned to perform certain tasks. These notifi

Why is it preferred to not use finalize for clean up, The Problem with fina...

The Problem with finalize is that the garbage collection has to make 2  rounds in order to remove the  objects which have finalize methods. The figure below will make things cle

Differences between the detailsview and formview controls, Question: (a...

Question: (a) Give three key differences between the DetailsView and FormView controls. (b) The ASP.NET 2.0 Framework introduces the idea of validation groups. How Valida

Raid and its working, What is RAID and how does it work? The Redundant ...

What is RAID and how does it work? The Redundant Array of Independent Disks (RAID) is a term used for describing the technique of improving data availability through the use of

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd