In moments of distress, the database consistency check (DBCC) may prove to be your most valuable friend. This tip provides a thumbnail sketch of the things DBCC can do for you...
This story continues at http://www.databasejournal.com/news/article.php/3650726
