I discuss several aspects of DBCC CHECKDB and offer suggestions to minimize the impact this crucial operation can have.

A lot of work went into improving estimates shown by an execution plan in Plan Explorer.

Tip : Auditing when Triggers are Enabled or Disabled