SQLpassion BLOG

Improving SQL Server Performance by using Instant File Initialization

Today I want to talk about a very specific topic in SQL Server – Instant File Initialization. If you have Instant File Initialization for your SQL Server Instance enabled, you can have a tremendous performance improvement – under specific circumstances. Instant File Initialization defines how the SQL Server engine interacts with the Windows OS, when …

Improving SQL Server Performance by using Instant File Initialization + read more

Announcing the SQLpassion Performance Tuning Training Plan

You are a developer and/or DBA and want to learn in a very compact way the essential things about performance tuning & troubleshooting SQL Server installations? In our new free 6 month long SQLpassion Performance Tuning Training Plan we give you week by week via email all the essential knowledge you need to know about …

Announcing the SQLpassion Performance Tuning Training Plan + read more