Source links:
- Official Microsoft Page
- Features Supported by the Editions of SQL Server 2016
- Features Supported by the Editions of SQL Server 2014
- Features Supported by the Editions of SQL Server 2012
- Features Supported by the Editions of SQL Server 2008
- Features Supported by the Editions of SQL Server 2005
- SQL Server Pricing
SQL Server 2016 is available in an Evaluation edition for a 180-day trial period. For more information, see the SQL Server Trial Software Web Site.
| Features | Enterprise | Business Intelligence | Standard | Express |
|---|---|---|---|---|
| Maximum number of cores | OS Max | 16 cores-DBOS Max-AS&RS2 | 16 cores | 4 cores |
| Maximum memory utilized per instance | OS Max | 128 GB | 128 GB | 1 GB |
| Maximum size | 524 PB | 524 PB | 524 PB | 10 GB |
| Programmability (T-SQL, data types, FileTable) | Yes | Yes | Yes | Yes |
| SQL Server Management Studio | Yes | Yes | Yes | Yes |
| Policy-based management | Yes | Yes | Yes | No |
| Basic OLTP | Yes | Yes | Yes | Yes |
| Basic security (Separation of duties, basic auditing) | Yes | Yes | Yes | Yes |
| Basic high availability | Yes | Yes | Yes | No |
| Built-in data connectors | Yes | Yes | Yes | Yes |
| Basic data integration (SSIS, designer transforms) | Yes | Yes | Yes | No |
| Basic reporting | Yes | Yes | Yes | Yes |
| Basic corporate BI (Analytics, multidimensional semantic model, data mining) | Yes | Yes | Yes | No |
| Self-service business intelligence (Alerting, Power View, Power Pivot for SharePoint Server) | Yes | Yes | No | No |
| Advanced corporate BI (Tabular BI semantic model, advanced analytics and reporting, in-memory analytics engine, advanced data mining) | Yes | Yes | No | No |
| Enterprise data management (Data Quality Services, Master Data Services) | Yes | Yes | No | No |
| Advanced data integration (Fuzzy grouping and lookup, change data capture) | Yes | No | No | No |
| Advanced security (SQL Server audit, transparent data encryption) | Yes | No | No | No |
| Data warehousing (In-memory columnstore, compression, partitioning) | Yes | No | No | No |
| Advanced high availability (AlwaysOn, multiple, active secondaries; multi-site, geo-clustering) | Yes | No | No | No |
| Advanced transaction processing (In-memory OLTP) | Yes | No | No | No |