Get more out of your data

Learn more about the editions of SQL Server 2016. Choose the edition that’s right for you based on features that increase performance, provide additional security, and transform your data into actionable insights.

SQL Server 2016 editions

Enterprise

Enterprise

Comprehensive, mission-critical in-memory performance with unparalleled security, an end-to-end enterprise business intelligence solution with mobile BI built-in, and in-database advanced analytics at scale. Enterprise edition provides the highest service and performance for Tier-1 workloads.

Learn more
Standard

Standard

Core data management and business intelligence capabilities with minimal IT resources.

Learn more
Express

Express

Entry-level, free database that is ideal for deploying small databases in production environments. Build desktop and small server, data-driven applications up to 10 GB of disk size.

Learn moreDownload
Developer

Developer

Free, full-featured set of SQL Server 2016 Enterprise edition software that allows developers to build, test, and demonstrate applications in a non-production environment.

Learn moreDownload

Compare SQL Server 2016 editions1

FeaturesSQL Server 2016 Enterprise SQL Server 2016 StandardSQL Server 2016 ExpressSQL Server 2016 Developer

Mission-critical performance

Maximum number of coresUnlimited24 cores4 coresUnlimited
Maximum memory utilised per instanceOperating system max128 GB1 GBOperating system max
Maximum size 524 PB524 PB10 GB524 PB
Production use rightsdot-icondot-icondot-icon
Basic OLTPdot-icondot-icondot-icondot-icon

Manageability: Management Studio, policy-based management

dot-icondot-icondot-icondot-icon

Basic high availability: 2-node single database failover, non-readable secondary

dot-icondot-icondot-icon

Enterprise data management: Master Data Services, Data Quality Services

dot-icondot-icon

Advanced OLTP: In-memory OLTP, operational analytics

dot-icondot-icon

Advanced High Availability: Always On Availability Groups, multi-database failover, readable secondaries

dot-icondot-icon

Security

Basic security: Row-level security, data masking, basic auditing, separation of duties

dot-icondot-icondot-icon

Advanced security: Transparent database encryption, Always Encrypted

dot-icondot-icon

Data warehousing

Advanced data integration: Fuzzy grouping and look ups, change data capture

dot-icondot-icon

Data warehousing: In-Memory Columnstore, partitioning

dot-icondot-icon
PolyBase2dot-icondot-icondot-icon

Business intelligence

Maximum memory utilized per instance of Analysis ServicesOperating system max
  • Tabular: 16 GB
  • MOLAP: 64 GB
Maximum memory utilized per instance of Reporting ServicesOperating system max64 GBExpress with Advanced Services: 4 GB

Programmability and developer tools: T-SQL, CLR, Data Types, FileTable, JSON

dot-icondot-icondot-icondot-icon
Basic reporting and analyticsdot-icondot-icondot-icondot-icon

Basic corporate business intelligence: Basic multi-dimensional models, basic tabular model, in-memory storage mode

dot-icondot-icondot-icon

Basic corporate business intelligence: Basic multi-dimensional models, basic tabular model, in-memory storage mode

dot-icondot-icondot-icon
Mobile reports and KPIsdot-icondot-icon

Advanced corporate business intelligence: Advanced multi-dimensional models, advanced tabular model, DirectQuery storage mode, advanced data mining

dot-icondot-icon

Advanced analytics

dot-icondot-icondot-icondot-icon

Advanced R integration: Full parallelism ScaleR

dot-icondot-icondot-icon

Hybrid cloud

Stretch Databasedot-icondot-icondot-icondot-icon
Features

Mission-critical performance

Maximum number of cores
SQL Server 2016 Enterprise
Unlimited
SQL Server 2016 Standard
24 cores
SQL Server 2016 Express
4 cores
SQL Server 2016 Developer
Unlimited
Features
Maximum memory utilised per instance
SQL Server 2016 Enterprise
Operating system max
SQL Server 2016 Standard
128 GB
SQL Server 2016 Express
1 GB
SQL Server 2016 Developer
Operating system max
Features
Maximum size
SQL Server 2016 Enterprise
524 PB
SQL Server 2016 Standard
524 PB
SQL Server 2016 Express
10 GB
SQL Server 2016 Developer
524 PB
Features
Production use rights
SQL Server 2016 Enterprise
dot-icon
SQL Server 2016 Standard
dot-icon
SQL Server 2016 Express
dot-icon
SQL Server 2016 Developer
Features
Basic OLTP
SQL Server 2016 Enterprise
dot-icon
SQL Server 2016 Standard
dot-icon
SQL Server 2016 Express
dot-icon
SQL Server 2016 Developer
dot-icon
Features

Manageability: Management Studio, policy-based management

SQL Server 2016 Enterprise
dot-icon
SQL Server 2016 Standard
dot-icon
SQL Server 2016 Express
dot-icon
SQL Server 2016 Developer
dot-icon
Features

Basic high availability: 2-node single database failover, non-readable secondary

SQL Server 2016 Enterprise
dot-icon
SQL Server 2016 Standard
dot-icon
SQL Server 2016 Express
SQL Server 2016 Developer
dot-icon
Features

Enterprise data management: Master Data Services, Data Quality Services

SQL Server 2016 Enterprise
dot-icon
SQL Server 2016 Standard
SQL Server 2016 Express
SQL Server 2016 Developer
dot-icon
Features

Advanced OLTP: In-memory OLTP, operational analytics

SQL Server 2016 Enterprise
dot-icon
SQL Server 2016 Standard
SQL Server 2016 Express
SQL Server 2016 Developer
dot-icon
Features

Advanced High Availability: Always On Availability Groups, multi-database failover, readable secondaries

SQL Server 2016 Enterprise
dot-icon
SQL Server 2016 Standard
SQL Server 2016 Express
SQL Server 2016 Developer
dot-icon
Features

Security

Basic security: Row-level security, data masking, basic auditing, separation of duties

SQL Server 2016 Enterprise
dot-icon
SQL Server 2016 Standard
dot-icon
SQL Server 2016 Express
SQL Server 2016 Developer
dot-icon
Features

Advanced security: Transparent database encryption, Always Encrypted

SQL Server 2016 Enterprise
dot-icon
SQL Server 2016 Standard
SQL Server 2016 Express
SQL Server 2016 Developer
dot-icon
Features

Data warehousing

Advanced data integration: Fuzzy grouping and look ups, change data capture

SQL Server 2016 Enterprise
dot-icon
SQL Server 2016 Standard
SQL Server 2016 Express
SQL Server 2016 Developer
dot-icon
Features

Data warehousing: In-Memory Columnstore, partitioning

SQL Server 2016 Enterprise
dot-icon
SQL Server 2016 Standard
SQL Server 2016 Express
SQL Server 2016 Developer
dot-icon
Features
PolyBase2
SQL Server 2016 Enterprise
dot-icon
SQL Server 2016 Standard
dot-icon
SQL Server 2016 Express
SQL Server 2016 Developer
dot-icon
Features

Business intelligence

Maximum memory utilized per instance of Analysis Services
SQL Server 2016 Enterprise
Operating system max
SQL Server 2016 Standard
  • Tabular: 16 GB
  • MOLAP: 64 GB
SQL Server 2016 Express
SQL Server 2016 Developer
Features
Maximum memory utilized per instance of Reporting Services
SQL Server 2016 Enterprise
Operating system max
SQL Server 2016 Standard
64 GB
SQL Server 2016 Express
Express with Advanced Services: 4 GB
SQL Server 2016 Developer
Features

Programmability and developer tools: T-SQL, CLR, Data Types, FileTable, JSON

SQL Server 2016 Enterprise
dot-icon
SQL Server 2016 Standard
dot-icon
SQL Server 2016 Express
dot-icon
SQL Server 2016 Developer
dot-icon
Features
Basic reporting and analytics
SQL Server 2016 Enterprise
dot-icon
SQL Server 2016 Standard
dot-icon
SQL Server 2016 Express
dot-icon
SQL Server 2016 Developer
dot-icon
Features

Basic corporate business intelligence: Basic multi-dimensional models, basic tabular model, in-memory storage mode

SQL Server 2016 Enterprise
dot-icon
SQL Server 2016 Standard
dot-icon
SQL Server 2016 Express
SQL Server 2016 Developer
dot-icon
Features

Basic corporate business intelligence: Basic multi-dimensional models, basic tabular model, in-memory storage mode

SQL Server 2016 Enterprise
dot-icon
SQL Server 2016 Standard
dot-icon
SQL Server 2016 Express
SQL Server 2016 Developer
dot-icon
Features
Mobile reports and KPIs
SQL Server 2016 Enterprise
dot-icon
SQL Server 2016 Standard
SQL Server 2016 Express
SQL Server 2016 Developer
dot-icon
Features

Advanced corporate business intelligence: Advanced multi-dimensional models, advanced tabular model, DirectQuery storage mode, advanced data mining

SQL Server 2016 Enterprise
dot-icon
SQL Server 2016 Standard
SQL Server 2016 Express
SQL Server 2016 Developer
dot-icon
Features

Advanced analytics

SQL Server 2016 Enterprise
dot-icon
SQL Server 2016 Standard
dot-icon
SQL Server 2016 Express
dot-icon
SQL Server 2016 Developer
dot-icon
Features

Advanced R integration: Full parallelism ScaleR

SQL Server 2016 Enterprise
dot-icon
SQL Server 2016 Standard
SQL Server 2016 Express
dot-icon
SQL Server 2016 Developer
dot-icon
Features

Hybrid cloud

Stretch Database
SQL Server 2016 Enterprise
dot-icon
SQL Server 2016 Standard
dot-icon
SQL Server 2016 Express
dot-icon
SQL Server 2016 Developer
dot-icon
Features
SQL Server 2016 Enterprise
SQL Server 2016 Standard
SQL Server 2016 Express
SQL Server 2016 Developer
Features
SQL Server 2016 Enterprise
SQL Server 2016 Standard
SQL Server 2016 Express
SQL Server 2016 Developer
Features
SQL Server 2016 Enterprise
SQL Server 2016 Standard
SQL Server 2016 Express
SQL Server 2016 Developer
Features
SQL Server 2016 Enterprise
SQL Server 2016 Standard
SQL Server 2016 Express
SQL Server 2016 Developer
Features
SQL Server 2016 Enterprise
SQL Server 2016 Standard
SQL Server 2016 Express
SQL Server 2016 Developer
Features
SQL Server 2016 Enterprise
SQL Server 2016 Standard
SQL Server 2016 Express
SQL Server 2016 Developer
Features
SQL Server 2016 Enterprise
SQL Server 2016 Standard
SQL Server 2016 Express
SQL Server 2016 Developer

1 View the comprehensive feature comparison of SQL Server 2016 editions for feature details and limitations.

2Scale out relational and non-relational data queries with the simplicity of T-SQL using PolyBase, which requires single Microsoft SQL Server 2016 Enterprise Edition as head node.​​

Other SQL Server 2016 editions

Compact

Compact

Free, embedded database app for building ASP.NET websites and Windows desktop applications.

Download the app
Web

Web

Secured, cost effective, and highly scalable data platform for public web sites. The Web edition is available to third party hosting service providers only.

Learn more