SQL Server Quickie #16 – Database Shrink Operations

Today I have uploaded the 16th SQL Server Quickie to YouTube. This time I’m talking about Database Shrink operations in SQL Server.

Like or share to get the source code.

Thanks for watching!

-Klaus

6 thoughts on “SQL Server Quickie #16 – Database Shrink Operations”

  1. Mark Workman

    We have 250GB of images that have been added into the database over the last 10 years. We would like to remove the images from the database and link to files in a filesystem.
    Our data size would go from 275GB to 50Gb or so. We will not be adding images further so it will grow more slowly. The images are the only thing in tha Secondary filegroup. Would we not want to reclaim the space in some way?
    Thanks
    Mark

    1. Klaus Aschenbrenner

      Hello Mark,

      Thanks for your comment.
      Of course, in that case you can run a Shrink operation.
      Shrinks are not always bad, but you have to be aware of the side-effects – like index fragmentation.

      Thanks,

      -Klaus

Leave a Reply to Klaus Aschenbrenner Cancel Reply

Your email address will not be published. Required fields are marked *