DBA Fundamentals: Maintenance: Shrinking Files
When you’ve got a lot of empty space inside a database, you can use DBCC SHRINKDB or SHRINKFILE in order to downsize the file and free up space on your drives. But should you? I’ll explain how those commands work, why they make performance worse, and give you alternatives.
Take the opportunity to connect and share this video with your friends and family if you find it useful.