Data and log files are first initialized by filling the files with zeros when you perform one of the following operations:
1) Create a database.
2) Add files, log or data, to an existing database.
3) Increase the size of an existing file (including autogrow operations).
4) Restore a database or filegroup.
Instant file initialization reclaims used disk space without filling that space with zeros.
This will help data files initialization instantaneously.
Steps to Enable Instant file initialization :
Go to Administrative tools –> Local security policy –> under local policies … select user Rights Assignment –>select …perform volume maintenance tasks –> properties — > add your SQL Server service account.
This will made database creations, file growths and file creations fast.
selectstarfromyogi 