ALTER DATABASE REMOVE AUTOSHRINK PERMANENTLY

When a database gets created, restored, or attached to SQL Server, this T-SQL command should execute by default. Seriously, if this command exists, that’s probably how most database administrators will find it applicable. The side effects of auto-shrink outweigh any potential benefits. Below are some of the disadvantages of auto-shrink. It will lead to indexes becoming …