Community

Script to verify if ‘Instant File Initialization’ is Enabled

(Larry Leonard) Instant file initialization is a wonderful feature of the Windows file system – not of SQL Server, please note — that allows the server to allocate disk pages without having to set each bit to zero.

Read More - Register for Free Membership