Instant File Initialization and Database Recovery
When SQL Server reserves new space on a disk, it initializes the space with zeros. This behavior can be switched off thereby reducingthe execution time of some operations and the load on the disk subsystem. Disk space reservation without initialization is called Instant File Initialization. This feature is not widely known, although its use has become possible starting with SQL Server 2005. The benefits of the Instant File Initialization are the following: 1. Accelerating the creation... » read more