With dimensionally modeled data warehouses, a big part of your workload typically consists of what are known as star join queries. These queries follow a common pattern that joins the fact table with one or several dimension tables.. GeoPITS brings you the comprehensive details of Autogenerate staging and data warehouse schema's support in different versions & editions of SQL Server.
| Version | Enterprise | Standard | Web | Express (Adv.) | Express |
|---|---|---|---|---|---|
| Version v2019 | Yes | Yes | |||
| Version v2017 | Yes | Yes | |||
| Version v2016 | Yes | Yes | |||
| Version v2014 | |||||
| Version v2012 |
With dimensionally modeled data warehouses, a big part of your workload typically consists of what are known as star join queries. These queries follow a common pattern that joins the fact table with one or several dimension tables.
You can find more details about this version here
Back to all features