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.  

To access this incredible, amazing content, you gotta get Fundamentals of Database Administration or Recorded Class Season Pass, or log in if you already shelled out the cash.