Hi everyone. I often hear DBAs at conferences talk about their "DBA database" where they hold all manner of tables for processes/statistics/baselines etc. I'm not a DBA however I am now managing our DB (SS2012), which has an OLTP application running on it. My question is what sort of processes/activities do you use this "DBA database" for? Thanks in advance.
In addition to @raadee's suggestions, I would have tally / numbers tables (not just numbers, but also for dates, times etc) to aid more interesting queries. See, for example, [this SQLServerCentral article] from the one and only Jeff Moden. :