Chapter 11. DBCC Internals
Paul Randal
When anyone mentions consistency checking a Microsoft SQL Server database, the first thing that comes to mind is "DBCC." In SQL Server 7.0, DBCC stood for Database Consistency Checker, but Microsoft changed the definition in the next release, SQL Server 2000, to Database Console Commands. This change reflected the fact that the DBCC command family had grown to do much more than just checking consistency, and also was intended to help dispel the perception that SQL Server databases required regular consistency checking because SQL Server itself caused corruption.
Although SQL Server itself does not cause database corruptions, I/O subsystems (all the software and hardware between the SQL Server buffer pool and ...
Get Microsoft® SQL Server® 2008 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.
