Instant File Initialization for the transaction log | SQL Server 2022 Hidden Gems | Data Exposed

Описание: Next in the SQL Server 2022 hidden gems series you'll learn about Instant file Initialization (IFI) behavior for Log file growth even with TDE enabled (does not require special privilege).

00:00 - Introduction
01:05 - Purvi's list
01:31 - Demo

✔️ Resources:
What's new in SQL Server 2022 (16.x): https://learn.microsoft.com/sql/sql-s...

✏️ Hidden Gems Playlist: https://aka.ms/sqlserver2022gems

📌 Let's connect:
Twitter - Anna Hoffman,   / analyticanna  
Twitter - Bob Ward,   / bobwardms  
Twitter - AzureSQL, https://aka.ms/azuresqltw

🔴 Watch even more Data Exposed episodes: https://aka.ms/dataexposedyt

🔔 Subscribe to our channels for even more SQL tips:
Microsoft Azure SQL: https://aka.ms/msazuresqlyt
Microsoft SQL Server: https://aka.ms/mssqlserveryt
Microsoft Developer: https://aka.ms/microsoftdeveloperyt

#AzureSQL #SQL #LearnSQL