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): learn.microsoft.com/sql/sql-s...
✏️ Hidden Gems Playlist: aka.ms/sqlserver2022gems
📌 Let's connect:
Twitter - Anna Hoffman, / analyticanna
Twitter - Bob Ward, / bobwardms
Twitter - AzureSQL, aka.ms/azuresqltw
🔴 Watch even more Data Exposed episodes: aka.ms/dataexposedyt
🔔 Subscribe to our channels for even more SQL tips:
Microsoft Azure SQL: aka.ms/msazuresqlyt
Microsoft SQL Server: aka.ms/mssqlserveryt
Microsoft Developer: aka.ms/microsoftdeveloperyt
#AzureSQL #SQL #LearnSQL

[@robcarrol]

Great work, thanks!

[@gandharjayantaundhe4023]

Great stuff! Thanks!

[@chetan061]

Really Interesting

[@user-fy7qr9gb4b]

Wonderful !!! how can i reach test script that You used it in Demo??

[@maheshshinde4168]

Cool.. no need to grant sp privileges to sql service account anymore