Database Administration

If you manage your SQL Server with a “keep it tight” approach, you may be losing some performance when SQL Server needs to allocate space to expand your data files.

Instant File Initialization was added several SQL Server releases ago.  The “Perform Volume Maintenance Tasks” policy is off by default preventing many SQL Server installations from taking advantage of the feature.