# Weekly Review: Auto Shrink for SQL Server is Evil

- URL: https://dynamicaccounting.net/weekly-review-auto-shrink-for-sql-server-is-evil/
- Date: 2010-07-29
- Topics: SQL & Data, Install, Upgrade & Admin, Tips & Hidden Features
- Type: link to an external article
- Source: https://www.sqlskills.com/about/paul-s-randal/

[Paul Randall](https://www.sqlskills.com/about/paul-s-randal/) is a guy a I listen to in the SQL Server space. Eight and half years on the SQL Server team at Microsoft will do that.

In this review we look at [Paul’s post on Auto Shrink for SQL Server](http://www.sqlskills.com/blogs/paul/auto-shrink-turn-it-off/) and why it’s bad. It causes severe index fragmentation for starters and Paul has the scripts to prove it, so you can reproduce the problem yourself. [Read the whole thing here.](http://www.sqlskills.com/blogs/paul/auto-shrink-turn-it-off/)

Ok so, Auto Shrink for waistline, good. Auto Shrink for SQL Server, Bad. Got it. Now all I have to do is find that Auto Shrink for waistline app.