Modify growth settings
In lots of databases, the file growth settings are left as the default value: 1MB or 10%. This is not optimal. It can cause all kinds of issues, which rear their ugly heads as performance problems.
We have created a SQL Server agent job that runs monthly on the first day of the month, setting the growth settings to the proper values according to the database size.
The query to create the job is attached.