Lowell (8/9/2011)
on the other hand, I know of DBA's who have never used the DMV's at all.Subjective Adapts covered the DBCC commands pretty well.
I dunno, would you say that a DBA doesn't use something until there is a problem that requires it?
I agree with that. I've been lucky and never had any major corruption issues (so far, knock wood, turn 3 times widdershins & spit), so I'm almost completely unfamiliar with some of those DBCC commands. I've read through them on several occasions (just in case), but not having used them, I plead ignorance to their appropriate application.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning