Conclusion
As you can see from the descriptions in this chapter, the consistency checks that SQL Server 2012 can perform on a database are extremely comprehensive and have evolved significantly from earlier releases in terms of breadth, depth, and efficiency.
Also, you can see why DBCC CHECKDB can take such a long time to complete on a large, complex database. I’ve tried to include information on most corruption errors that DBCC CHECKDB can report, as well as background on the consistency-checking mechanisms that it used to arrive at its conclusions.
This information should help you if and when you encounter corruption in your own databases.
Get Microsoft SQL Server 2012 Internals now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
