Hi Steve, nice article, thanks. The Paul S. Randal article you linked to was also very interesting. What sort of frequency would you run CHECKDB on your databases? Would this be a weekly thing? Do you run it with no arguments. I'm just curious as to the typical usage. I notice it hasn't run for a while on some of our production DBs which makes me a little concerned!
I'm guessing this is the sort of thing that you schedule to run overnight or overnight on the weekend when the impact would be reduced?