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

 Posted on 08/03/2018

                                                                                                                                                                               
Share On: facebook gplus twitter
profile
Asked by Hardik Parekh on 08/03/2018 Score: 234 points
Add Comment:

Comments

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

1 Answers

0 Corrected Answers
Aproved Answers
2
Profile
Answered by hardik chaudhary on 8/3/2018 12:39:14 PM Score: 454 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

Comments

Add Comment:

Post Your Answers

Existing Members

Sign in to your account
Email Address
Password
New Member?
Sign up and complete profile
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.