SQL Server with Mr. Denny:

Instant File Initialization


December 4, 2008  7:55 AM

Getting rid of Instant File Initialization (or enabling it if that strikes your fancy)

Posted by: Denny Cherry
Instant File Initialization, Performance Problems, Storage

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...


Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: