Getting rid of Instant File Initialization (or enabling it if that strikes your fancy)
SQL Server 2005 introduced us to Instant File Initialization. This allows SQL Server to create files of any size without sitting there for minutes or hours (depending on the size of the files). While this is great when creating your database, or extending your database files there is a cost to doing so. Before each […]