Assessing the Impact of AUTO_SHRINK on Azure SQL Databases on SSDs

Using AUTO_SHRINK on SSD-based SQL databases harms performance, causes fragmentation, and strains SSDs unnecessarily. Microsoft advises against it.

Read more