Below, in the table provided, we will compare four editions of SQL Server 2017: SQL Server 2017 Enterprise, SQL Server 2017 Standard, SQL Server 2017 Express, and SQL Server 2017 Developer. We will look at their features and the differences between them.
You can purchase an original product key for Microsoft SQL Server 2017 on the next page in our online store. Fast delivery to your email. Warranty and 24/7 technical support.
| Functions | SQL Server 2017 Enterprise | SQL Server 2017 Standard | SQL Server 2017 Express | SQL Server 2017 Developer |
|---|---|---|---|---|
| Maximum number of cores | No limit | 24 cores | 4 cores | No limit |
| Memory: Maximum buffer pool size per instance | Operating system (max.) | 128 GB | 1410 MB | Operating system (max.) |
| Memory: Maximum Columnstore segment cache per instance | Operating system (max.) | 32 GB | 352 MB | Operating system (max.) |
| Memory: Maximum in-memory optimized data size per database | Operating system (max.) | 32 GB | 352 MB | Operating system (max.) |
| Maximum database size | 524 PB | 524 PB | 10 GB | 524 PB |
| Usage rights in production environments | ✅ | ✅ | ✅ | ❌ |
| Unlimited virtualization, Software Assurance benefits | ✅ | ❌ | ❌ | ❌ |
| Programming and developer tools: T-SQL, SQL CLR, Service Broker, JSON, XML, graph data support | ✅ | ✅ | ✅ | ✅ |
| Advanced OLTP: In-memory OLTP, operational analytics | ✅ | ✅ | ✅ | ✅ |
| Management capabilities: Management Studio, policy-based management | ✅ | ✅ | ✅ | ✅ |
| Basic high availability: Two-node failover, read-only secondary replica | ✅ | ✅ | ❌ | ✅ |
| Advanced high availability: Always On availability groups, multi-database failover, readable secondary replicas | ✅ | ❌ | ❌ | ✅ |
| Enhanced security: Always Encrypted, row-level security, data masking | ✅ | ✅ | ✅ | ✅ |
| Compliance reporting with SQL Server auditing | ✅ | ✅ | ✅ | ✅ |
| Transparent data encryption | ✅ | ❌ | ❌ | ✅ |
| Advanced data integration: Fuzzy grouping and lookup | ✅ | ❌ | ❌ | ✅ |
| Data warehousing and storage: Partitioning, data compression, change data capture, database snapshots | ✅ | ✅ | ✅ | ✅ |
| Adaptive query processing | ✅ | ❌ | ❌ | ✅ |
| PolyBase | ✅ | ✅ | ✅ | ✅ |
| Enterprise data management: Master Data Services, Data Quality Services | ✅ | ❌ | ❌ | ✅ |
| Maximum memory per instance of Analysis Services | Operating system (max.) | Tabular: 16 GB MOLAP: 64 GB | ❌ | ❌ |
| Maximum memory per instance of Reporting Services | Operating system (max.) | 64 GB | Express with Advanced Services: 4 GB | Operating system (max.) |
| Basic reporting and analytics | ✅ | ✅ | ✅ | ✅ |
| Basic data integration: SQL Server Integration Services, built-in connectors | ✅ | ✅ | ❌ | ✅ |
| Basic enterprise BI: Basic multidimensional models, basic tabular model, in-memory storage mode | ✅ | ✅ | ❌ | ✅ |
| Mobile reports and KPIs | ✅ | ❌ | ❌ | ✅ |
| Advanced enterprise BI: Advanced multidimensional models, advanced tabular model, DirectQuery storage mode, advanced data mining | ✅ | ❌ | ❌ | ✅ |
| Access to Power BI Report Server, Software Assurance benefits | ✅ | ❌ | ❌ | ❌ |
| Basic machine learning integration: Open-source Python and R connectivity, limited parallelism | ✅ | ✅ | ✅ | ✅ |
| Advanced machine learning integration: Full parallelism for R and Python analytics, GPU execution | ✅ | ❌ | ❌ | ✅ |
| Machine learning for Hadoop/Spark and Linux, Software Assurance benefits | ✅ | ❌ | ❌ | ❌ |
| Stretch Database | ✅ | ❌ | ❌ | ❌ |
