Is SQL Server 2016 Standard Edition SP1 support switch partition?

Question

We have developed a data archiving process using switch partition mechanism in SQL Server Enterprise Edition.

We want to use the same mechanism in SQL Server Standard edition. We came to know that partitioning is supported in SQL Server Standard Edition SP1. But we are not sure whether switch partition is supported in SQL Server Standard edition or not.

Dan Guzman Dan Guzman · Accepted Answer · 2018-02-15T13:10:52

All editions of SQL Server 2016 SP1 and later support the same surface area for table partitioning features, including partition-level SWITCH. However, editions besides Enterprise (and Developer) don't support performance features like partitioned table parallelism.

Is SQL Server 2016 Standard Edition SP1 support switch partition?

1 Answers