- "... a scholar and a true gentleman." - Buck Woody, Microsoft's "Real World" SQL Server DBA.
- Agresso AskSSC Assyst Axios Azure Backup Book Review Books Career Certification Cluster Configuration CSV CTE DBCC Denali Deployment Design Disaster Recovery Documentation Education Error Message ETL Execution Plans Full Text Indexes Indexing Installation IT Management Kaseya Kindle Maintenance Maintenance Plans Management Meme Monday Memory Migration Misconceptions Monitoring MSDB Myths Normalization People Performance PowerShell Programming red-gate Restore SQL Agent SQLBits SQL Monitor SQLPrompt SQLSaturday SQL Server SQL Server 2000 SQL Server 2005 SQL Server 2008 R2 SQL Server 2012 SQL Server 2014 SQLSouthWest SSMS ssmstoolspack SSRS T-SQL T-SQL Tuesday Tools Training Troubleshooting Un-SQL Friday Upgrade User Group Virtual Machines Windows 2012 WordPress WTF XML
Tag Archives: DBCC
I was trying to turn on Traceflag 3226 in order to suppress the swarm of successful transaction log backup messages that floods the SQL Server (Error) Logs (& Windows Application logs). After all, if you’ve got more than a few … Continue reading →
This is a long-winded response to a query raised on AskSSC, about how to report on the running of DBCC. One way suggested was to use Ola Hallengren’s scripts to schedule and report. However, I have another way that I … Continue reading →
We have (had?) an application that has been retired (Hurrah!). However, even though it has been retired, there is still the occasional request to extract data from this database, which was hosted on a SQL2000 SP3a server. So what I’m … Continue reading →