data-konzept

'I hate DBCC Commands.

Not what they do, just that the syntax isn’t consistent (do I need quotes around this string or not?), the results are a distraction to get into a usable table, and you need to write absurd loops to perform object-at-a-time data gathering. I’m not talking about running DBCC CHECKDB (necessarily), or turning on Trace Flags, or any cache-clearing commands — you know, things that perform actions — I mean things that spit tabular results at you.

Stuff like this puts the BC in DBCC. It’s a dinosaur.'...

https://www.brentozar.com/archive/2016/04/old-busted-dbcc-commands-2016/?utm_source=Brent+Ozar+Unlimited%C2%AE+List&utm_campaign=5a0131d8a5-RSS_EMAIL_CAMPAIGN&utm_medium=email&utm_term=0_8e3e861dd9-5a0131d8a5-296247489