SQL Server optimization
Modify growth settings
In lots of databases, the file growth settings are left as the default value: 1MB or 10%. This is...
Change the target recovery time
This article describes how to set or change the target recovery time of a database in SQL Server ...
Enable query store
Since SQL Server 2016, there has been an option to enable a query store. The query store stores d...