Instant File Initialization (IFI)

Ability to enable Instant File Initialization during the installation of SQL Server 2016.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(4)

You rated this post out of 5. Change rating

2016-05-03

1,371 reads

Instant File Initialization

This article describes a way to speed up various file operations performed by SQL Server.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(16)

You rated this post out of 5. Change rating

2014-07-10

4,451 reads

If you're an attendee at the PASS Data Community Summit this year, there are...

dead reckoning– v. intr. finding yourself bothered by somebody’s death more than you would...

Thank you for attending my PASS Summit 2025 session Answering the Auditor’s Call with...

Comments posted to this topic are about the item Personal Contact Is Vital

Comments posted to this topic are about the item Getting the Schema for Tables

Comments posted to this topic are about the item An Unexciting Exciting Release

What happens when I run this on SQL Server 2022 in the AdventureWorks2022 database?

SELECT OBJECT_DEFINITION (OBJECT_ID(N'Person.Person')) AS [Object Definition]; 
GO