The end of IFI problem with SQL Server 2016 CTP3.0

As mentioned in this article,¬†until SQL Server 2014, due to a system configuration, whenever it was necessary to increase the size of a database file, the operative system had to reset (“zeroing out”) the portion of the incremented file.

Now in CTP3.0 version of SQL Server 2016, as can be seen in the following image, with just one click, you can set the instant file initialization solving the problem of “zeroing out” the files.

IFI SQL Server 2016 CTP3

This is just one of the new features in SQL Server 2016 installation.