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)

Fill factor, What is fill factor? The 'fill factor' option describes ho...

What is fill factor? The 'fill factor' option describes how full SQL Server will make each index page. When there is no free space to insert a new row on the index page, the SQ

Jquery and mvc project, I am looking individuals who have company experienc...

I am looking individuals who have company experience working on Jquery and Microsoft Technology ( MVC 4.5 ), who will take live online session and provide training through Team Vie

Document type definition (dtd), What is DTD? The Document Type definiti...

What is DTD? The Document Type definition (DTD) defines how your XML should structure. For illustrate in the above XML we want to make it compulsory to provide "qty" and "total

We''re seeking an it candidate, Project Description: We're seeking an IT...

Project Description: We're seeking an IT candidate with experience to help us optimizely,  Skills required: .NET, C# Programming, ASP, eCommerce, SQL

Tutoring, Hi, I have been working on Dot Net over the past few years. I wou...

Hi, I have been working on Dot Net over the past few years. I would like to do online tutoring for .NET. Could you please let me know the possible oppurtunities

Types of dependencies in cache, What are the types of dependencies in cache...

What are the types of dependencies in cache? Whenever you add an item to the cache, the dependency relationships is define that can force that item to be removed from the cache

Create custom controls in asp.net, How can we create custom controls in ASP...

How can we create custom controls in ASP.NET? The User controls are created using .ASCX in ASP.NET. After that .ASCX file is created you need two things in order to that the AS

What happens when aspx page is requested from browser ?, The steps that occ...

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

Asp .net mvc tutor, ASP .NET MVC Tutor Project Description: Work with...

ASP .NET MVC Tutor Project Description: Work with me and assist with troubleshooting lessons, describe in easy to understand terms how to accomplish certain tasks, provide co

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