PLAY PODCASTS
Episode 90 Check DBCC

Episode 90 Check DBCC

SQL Data Partners Podcast · Marathon Consulting

April 5, 20171h 11m

Audio is streamed directly from the publisher (traffic.libsyn.com) as published in their RSS feed. Play Podcasts does not host this file. Rights-holders can request removal through the copyright & takedown page.

Show Notes

DBCC CheckDB. It is a simple command, but one that can cause database contention, dba stress, confusing results, dba elation, and everything in between. At one time we will all have to face the results of having a corruption issue and we're delighted to have Sean McCown with us again to discuss the ins and outs of the issues of this command. If you can remember, Sean was our guest in Episode 41. He is an SQL Server MVP with more than 15 years experience.

We talk with Sean about how frequent issues we have with maintenance like we often we should run CheckDB on our databases or what happens when I can only check one database during my window. While we don't end up discussing the command as much, we definitely review all aspects of making sure it can run in ALL environments.

The shownotes for today's episode is found at http://sqldatapartners.com/2017/04/05/dbcc-checkdb/ and have fun on the SQL trail.