Question of the Day Seventeen
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!
Posted on August 19, 2012, in SQL Schoolhouse and tagged SQL Learning. Bookmark the permalink. Leave a comment.
Leave a comment