I want to upgrade my SQL Server 2008 Enterprise Edition to SQL Server 2016 Standard Edition; however, one database makes use of table partitions over multiple file groups (used on a large logging table, each day is a partition)
I see in Editions and Supported Features for SQL Server 2016 under the section "RDBMS Scalability and Performance", that it says that Standard Edition supports Table and index partitioning, but it does not support Partitioned Table Parallelism.
I am not sure that I fully understand the consequences of this.
What exactly does it mean in my case, and how will it affect the database's performance?
Best Answer
Starting with SQL Server 2016 SP1 the Standard Edition supports
all functionalitymost programming surface of the Enterprise Edition, as announced here: SQL Server 2016 Service Pack 1 (SP1) released !!!.Quoted from that article:
What still differentiates EE from SE are primarily performance and administrative improvements.
So, in your case, SE will support table partitioning (functionality) but will not leverage certain performance enhancements available on partitioning, like 'partitioned table parallelism'.