Let us continue our question of the day series with day seventeen.

What is instant file initialization?

Instant file initialization allows for a file to be created or also to grow instantly.  Therefore it does require the process to zero out the space inside of the file.   It is important to point out that this only applies to SQL Server data files.  Enjoy!