SQL Server 2016 SP1 – Enterprise features in standard

Microsoft really surprised me with the realease of SQL Server 2016 SP1. They actually added some of the features to Standard and Express edition that used to be limited to Enterprise edition. Some of these features has been the main reason to use Enterprise edition like:

·    Compression

·    Partitioning

·    Column store index

·    InMemory tables

·    Polybase

·    R

This is really good news for all of you that are using standard edition, but there are still some limitations that you need to be aware of, like:

·    Index rebuild is still an offline operation that will block other operations

·    The amount of RAM and total number of cores are limited.

It still makes sense to use Enterprise in production to make sure you have the best performance and the highest availability, but for a test or stage environment you could use standard edition.

A side effect of the compression feature in Standard edition is that you actually can store more data in the cache that is limited to 128GB as the data is also compressed in RAM.

You can compare editions here

SQL Blog
Service packs
SQL Server 2016
SQL Server performance
Latest posts
  • Black Friday Alla e-handlares dröm! Eller mardröm? 2017-11-23
  • SQL Server 2016 SP1 – Enterprise features in standard 2017-01-18
  • SQL Server 2016 SP1 – CREATE OR ALTER 2016-11-16
  • Nyheterna i SQL Server 2016 2016-05-27
  • SQL Server 2005 - R.I.P. 2016-04-12
  • SQL Server 2016 – MAXDOP per database 2016-04-07
  • SQL Server 2016 News – Truncate partition 2016-04-05
  • SQL server 2016 – Labcenter 2W 2015-10-25