# Auto Shrink and SQL Index Fragmentation

- URL: https://dynamicaccounting.net/auto-shrink-and-sql-index-fragmentation/
- Date: 2007-11-13
- Topics: SQL & Data
- 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.

Today [Paul dropped a 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.