O'Reilly logo

Microsoft® SQL Server® 2008 Internals by Paul Randal Kalen Delaney Kimberly Tripp, and Conor Cunningham

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Per-Table Logical Consistency Checks

These checks verify the consistency for all structures in a table and all its indexes. In this section, when I say "a table," I mean "all partitions of the heap or clustered index, all partitions of all nonclustered indexes, and any off-row LOB data." The table could be a regular table, an indexed view, an XML index, a system catalog, a spatial index, a Service Broker queue, or any other database object that is stored internally as a table.

All the tables within a single batch are checked at the same time, using the fact-generation and fact-aggregation algorithms described previously. The first batch contains the critical system tables, and then subsequent batches are built and checked until all tables in the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required