Does DBCC Checkdb (db) with no parameters actually do anything besides
produce a report? Does it help keep the internal page allocations etc.,
intact or is that just wishful thinking on my part?
MS Sql Server LazyDBA home page