SQL Server Quickie #16 – Database Shrink Operations

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.)

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 Comments

  • mashrur shuvo

    Hi Klaus,

    Your Free Videos are very help full.

    Mashrur

  • Vinh Phan

    Thank Klaus very much, all video and articles are very useful. I love it so much

  • 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

    • 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

It`s your turn

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

SQLpassion

Copyright © 2015 by SQLpassion · Klaus Aschenbrenner · Imprint · Offerings · Academy · Contact · Go to Top