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.
Видео DBA Fundamentals: Maintenance: Shrinking Files канала Brent Ozar Unlimited
Видео DBA Fundamentals: Maintenance: Shrinking Files канала Brent Ozar Unlimited
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![DBA Fundamentals: Patching SQL Server](https://i.ytimg.com/vi/H8v6hvTEr1Q/default.jpg)
![Senior DBA Class - Index Maintenance for Enterprise Environments](https://i.ytimg.com/vi/VajLqrLfj4s/default.jpg)
![](https://i.ytimg.com/vi/nLSY3ZGa35Q/default.jpg)
![The Top 10 Developer Mistakes That Won't Scale on Microsoft SQL Server](https://i.ytimg.com/vi/YHgWBg2iGVw/default.jpg)
![DBA Fundamentals: Backups 2: Restores](https://i.ytimg.com/vi/c9tjmhNAaP8/default.jpg)
![Office Hours: Ask Me Anything About SQL Server](https://i.ytimg.com/vi/sw2v_TInvac/default.jpg)
![DBA Fundamentals Configuring TempDB](https://i.ytimg.com/vi/YGMCUZ9oBV0/default.jpg)
![Interview Questions From Database Pros](https://i.ytimg.com/vi/4as5GV884lw/default.jpg)
![Identifying and Fixing Parameter Sniffing Issues](https://i.ytimg.com/vi/pd7xqLT_-2k/default.jpg)
![DBA Fundamentals: Corruption: Checking for Corruption](https://i.ytimg.com/vi/jFBACVtQWQw/default.jpg)
![Backups 1: 3 Common Strategies](https://i.ytimg.com/vi/NuwDF6kzONs/default.jpg)
![Office Hours: Ask Me Anything About SQL Server at Vestrahorn](https://i.ytimg.com/vi/TE2y8nKioG8/default.jpg)
![What To Do When SQL Server is Slow Brent Ozar](https://i.ytimg.com/vi/aZm7FNxZyvE/default.jpg)
![DBA Fundamentals - Backups 3 - Setting Up Maintenance Plans](https://i.ytimg.com/vi/7zlCBhvFkhM/default.jpg)
![DBA Fundamentals: Configuration: Database Mail](https://i.ytimg.com/vi/WjhJJxZeU9w/default.jpg)
![DBA Fundamentals: Maintenance: Agent Jobs](https://i.ytimg.com/vi/kLu7G5W7Yyw/default.jpg)
![Office Hours: Ask Me Anything About Professional Development](https://i.ytimg.com/vi/iy1F8RrVAqg/default.jpg)
![SQL Server 2019's new Accelerated Database Recovery](https://i.ytimg.com/vi/MbvucNJL5H0/default.jpg)
![Office Hours: Ask Me Anything](https://i.ytimg.com/vi/WteaTqKAnYk/default.jpg)
![How Do I Know If My Query is Good Enough for Production?](https://i.ytimg.com/vi/yJgwQP84PdE/default.jpg)