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)

Develop outlook add-in for all versions, Develop Outlook Add-In for all ver...

Develop Outlook Add-In for all versions I need simple code for Outlook(express,2003,2007,2010,2013) Add-In with functionality to repeatedly send CC to the specified email(s), th

Difference between class and structure, What is the difference between Clas...

What is the difference between Class and structure's? The main differences between them are as follows:- 1) The Structure is value types while classes are referen

Globalization, how to access global resource file using javascript

how to access global resource file using javascript

Assign page specific attributes, How do we assign page specific attributes?...

How do we assign page specific attributes? The Page attributes are specified by using the @Page directive.

How to connect to microsoft access, How can we connect to Microsoft Access,...

How can we connect to Microsoft Access, Foxpro , Oracle etc ? The Microsoft provides System.Data.OleDb namespace to communicate with the databases such as Oracle, scess  etc. I

Android to pc communications via bluetooth, Project Description: I am lo...

Project Description: I am looking an app that mimics this app presently available here [justremotephone.com]. It has a nice set of features but also lacks a lot when it comes to

Medical related application in .net, Medical related application in .NET (d...

Medical related application in .NET (document, Videos editing must) Project Description: I am seeking a .NET Web application which can do the subsequent: 1. Taking patient

Need help to setup site minder agent to work with sharepoint, Site minder A...

Site minder Authentication in SharePoint We have fit site minder agent in SharePoint 2010. We would like to have incorporate with site minder agent. Currently site-minder age

Recipe house, recipe house Project Description: Web application with ...

recipe house Project Description: Web application with sql database Skills required are .NET, C# Programming, HTML, PHP, SQL

Writing project with uml diagram, Project Description:                     ...

Project Description:                                   Urgently require an expert with good knowledge of writing experience and UML diagrams. This project requires technologi

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