What is DBCC command and why is it used?Ask Questions

 Posted on 03/08/2018 7:32:04 AM

                                                                                                                                                                               
Share On: facebook gplus twitter
profile
Asked by Hardik Parekh on 03/08/2018 7:32:04 AM Score: 238 points
Add Comment:
Submit

Comments

answer plz
08/08/2018   16:01:37   Hardi Sananse

1 Answer

0 Corrected Answers
2
Profile
Answered by Hardik Bera on Aug 3 2018 12:39PM Score: 375 points

DBCC Command :

DBCC stands for Database consistency checker. DBCC commands act as database console commands which means that they are used to check the consistency of SQL server database.

DBCC Command Use :

Database Consistency Checker Commands give details in form of statistics about the SQL Server. They can be used for Maintenance of database, index, or filegroup. DBCC Commands can be used to perform validation operations on a database, table, index, catalog, filegroup, or allocation of database pages.

They can perform miscellaneous tasks such as enabling trace flags or removing a DLL from memory. DBCC INDEXDEFRAG, DBCC ERRORLOG, DBCC CACHESTATS are one of the few DBCC commands.

 

Ex : to checks the data page integrity of the author table

DBCC CHECKTABLE ('sample')

GO

Add Comment:

Post Your Answer

  •  
  •  

Existing Members

Sign in to your account
Email Address
Password
...or Join us
Download, Vote, Comment, Publish.
Full Name
Email Address
I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the StoodQ newsletters
Guideline to answer a question:

Useful tips to submit your answer
Please read below guidelines before you submit your answer for question.

  • Read and understand question for which you are submitting your answer.
  • Try to avoid grammatical and spell mistake while answering.
  • Do not post any irrelevant information in your answer.
  • Explain your answer with example or any reference link to help who posted question.
  • If you find irrelevant question, please report it to support. Click here to contact support.
  • You agree to the privacy policy and terms of use to submit any contents.

Note: StoodQ is online developers community which helps developer for their difficulty, lets help them with your value contribution.