Instant File Initialization - Killer Feature for SQL Server
When SQL Server reserves new space on a disk, it initializes the space with zeros. This behavior can be switched off thereby reducing the execution time of some operations and the load on the disk subsystem.
November 24, 2015
SQL Server Index Fragmentation In-depth
There is no way to avoid index fragmentation in any SQL Server environment. It does not depend on your SQL Server version or I/O subsystem you have, or your hardware. In this article, we will drill down ...
November 09, 2015