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

mashrur shuvo
08/25/2014 at 1:29 PM

Hi Klaus,

Your Free Videos are very help full.

Mashrur

Reply
1. Klaus Aschenbrenner
  08/26/2014 at 8:46 AM
  
  Hello Mashrur,
  
  Thanks for the nice feedback 🙂
  
  Best regards,
  
  -Klaus
  
  Reply
Vinh Phan
08/27/2014 at 1:29 PM

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

Reply
1. Klaus Aschenbrenner
  08/27/2014 at 2:06 PM
  
  Hello Vinth,
  
  Thanks for the great feedback!
  
  Best regards,
  
  -Klaus
  
  Reply
Mark Workman
07/10/2015 at 3:04 PM

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

Reply
1. Klaus Aschenbrenner
  07/10/2015 at 4:53 PM
  
  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
  
  Reply

SQLpassion Performance Tuning Training Plan – Signup