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,376 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,460 reads

A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...

Every year, the South Carolina State Internal Auditors Association and the South Carolina Midlands...

Data Céilí 2026 Call for Speakers is now live! Data Céilí (pronounced kay-lee), is...

Comments posted to this topic are about the item T-SQL in SQL Server 2025:...

Comments posted to this topic are about the item Your Value from a Conference

Comments posted to this topic are about the item UNISTR Basics

What does this code return in SQL Server 2025+? (assume the database has an appropriate collation)

SELECT UNISTR('Hello 4E16754C') AS 'A Classic';