Tag Archives: DBCC

  1. Using DBCC CLONEDATABASE to create a schema only copy of your database.

    Leave a comment

    August 11, 2022 by Kenneth Fisher

    DBCC CLONEDATABASE is one of those features that I don’t use often but it’s really cool when I need it. …
    Continue reading

  2. Shrinking a large database with limited outage windows


    April 22, 2019 by Kenneth Fisher

    Yes, I realize you shouldn’t shrink your database (data files or log files), but I recently had a case where …
    Continue reading

  3. Why shouldn’t I shrink my database data file?


    November 20, 2017 by Kenneth Fisher

    A while back I did a post about why you shouldn’t shrink your log file. This one is going to …
    Continue reading

  4. Why shouldn’t I shrink my database log file?


    May 15, 2017 by Kenneth Fisher

    TL;DR: It’s pretty pointless and can cause performance issues. Let’s start by asking why you might want to shrink your …
    Continue reading

  5. I need help with DBCC


    June 6, 2016 by Kenneth Fisher

    Many years ago during an interview I was asked to “Name the top 7 DBCC commands that you use.” I …
    Continue reading

  6. Does SQL Server do a CHECKDB during an instance restart?


    May 7, 2014 by Kenneth Fisher

    When you start up an instance do you rely on the CHECKDB entry in the error log of SQL Server …
    Continue reading

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 3,755 other subscribers

Follow me on Twitter

ToadWorld Pro of the Month November 2013