If you frequently run queries that involve an equi-join between two or more partitioned tables, their partitioning columns should be the same as the columns on which the tables are joined. GeoPITS brings you the comprehensive details of Parallel query processing on partitioned tables and indexes's support in different versions & editions of SQL Server.
| Version | Enterprise | Standard | Web | Express (Adv.) | Express |
|---|---|---|---|---|---|
| Version v2019 | Yes | ||||
| Version v2017 | Yes | ||||
| Version v2016 | Yes | ||||
| Version v2014 | |||||
| Version v2012 |
If you frequently run queries that involve an equi-join between two or more partitioned tables, their partitioning columns should be the same as the columns on which the tables are joined
You can find more details about this version here
Back to all features