Monthly Archives: February 2016

New things that you will see when installing SQL Server 2016

Hello everyone! My SQL Server 2014 Evaluation Edition just expired on my laptop and so I decided to try out the new SQL Server 2016 CTP 3.2. Below are new options that I found when installing in the feature selection page.


In the server configuration page, you can see the volume maintenance tasks option is provided which will enable the Instant File Initialization feature that was previously not available as an option directly.


In the Database Engine configuration page, you can see the tempdb file path configuration is moved to a separate tab.


Interesting feature is that SQL Server is providing the option to create multiple tempdb data files and also can see the number of files will be automatically be taken depending on the number of CPU cores on our server.