Tag Archives: Windows Instant File Initialization

Windows Instant File Initialization and SQL Server

One Windows setting that I think is extremely important for SQL Server usage is the “Perform volume maintenance tasks” right, which enables Windows Instant File Initialization. On a Windows Server 2003 or newer operating system, using SQL Server 2005 or … Continue reading

Posted in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 | Tagged | 16 Comments