SQL Server 2016 SP1 Out: Standard Edition has all Enterprise Edition Features 17


Big news at today’s Microsoft Connect conference: Service Pack 1 is out.

The list of features is awesome, but here’s the biggest news: almost all of the features of Enterprise Edition are now available in Standard Edition. That’s right: it’s time to get jiggy with the online index rebuilds, partitioning, compression, and more.

There’s one big restriction: for more than 4 sockets, more than 24 cores, or more than 128GB RAM, you’ll need Enterprise Edition.

After installing SP1, make sure to revisit your maintenance plans and index rebuild scripts – time to start taking advantage of online index rebuilds. Enjoy!


Leave a comment

Your email address will not be published. Required fields are marked *

17 thoughts on “SQL Server 2016 SP1 Out: Standard Edition has all Enterprise Edition Features