[SQL Server]: compare different SQL Server versions
Https://www.microsoft.com/zh-cn/server-cloud/products/sql-server/comparison.aspx
Compare the features of each SQL Server version
SQL Server 2016SQL Server 2014SQL Server 2012SQL Server 2008 R2
Functional features
Performance OLTP* in memory
SQL Server 2016
SQL Server 2014
SQL Server 2012
SQL Server 2008 R2
Functional features
Column storage in memory *
SQL Server 2016
SQL Server 2014
SQL Server 2012
SQL Server 2008 R2
Functional features
Real-time operational analysis *
SQL Server 2016
SQL Server 2014
SQL Server 2012
SQL Server 2008 R2
Functional features
Resource governor *
SQL Server 2016
SQL Server 2014
SQL Server 2012
SQL Server 2008 R2
Functional features
Query storage
SQL Server 2016
SQL Server 2014
SQL Server 2012
SQL Server 2008 R2
Functional features
Availability AlwaysOn*
SQL Server 2016
SQL Server 2014
SQL Server 2012
SQL Server 2008 R2
Functional features
Enhanced virtualization support and real-time migration
SQL Server 2016
SQL Server 2014
SQL Server 2012
SQL Server 2008 R2
Functional features
Security is always encrypted *
SQL Server 2016
SQL Server 2014
SQL Server 2012
SQL Server 2008 R2
Functional features
Transparent data encryption *
SQL Server 2016
SQL Server 2014
SQL Server 2012
SQL Server 2008 R2
Functional features
Row-level security
SQL Server 2016
SQL Server 2014
SQL Server 2012
SQL Server 2008 R2
Functional features
Dynamic data mask
SQL Server 2016
SQL Server 2014
SQL Server 2012
SQL Server 2008 R2
Functional features
Backup encryption support
SQL Server 2016
SQL Server 2014
SQL Server 2012
SQL Server 2008 R2
Functional features
Fine-grained audit
SQL Server 2016
SQL Server 2014
SQL Server 2012
SQL Server 2008 R2
Functional features
Separation of duties
SQL Server 2016
SQL Server 2014
SQL Server 2012
SQL Server 2008 R2
Functional features
Programmability JSON support
SQL Server 2016
SQL Server 2014
SQL Server 2012
SQL Server 2008 R2
Functional features
PolyBase query through Hadoop data * *
SQL Server 2016
SQL Server 2014
SQL Server 2012
SQL Server 2008 R2
Functional features
Temporary
SQL Server 2016
SQL Server 2014
SQL Server 2012
SQL Server 2008 R2
Functional features
Cloud ready SQL Server Stretch Database
SQL Server 2016
SQL Server 2014
SQL Server 2012
SQL Server 2008 R2
Functional features
Backup to Azure
SQL Server 2016
SQL Server 2014
SQL Server 2012
SQL Server 2008 R2
Functional features
Disaster recovery to Azure*
SQL Server 2016
SQL Server 2014
SQL Server 2012
SQL Server 2008 R2
Functional features
Optimized virtual machine image in Azure library
SQL Server 2016
SQL Server 2014
SQL Server 2012
SQL Server 2008 R2
Functional features
Manage Distributed Replay
SQL Server 2016
SQL Server 2014
SQL Server 2012
SQL Server 2008 R2
Functional features
Policy-based management
SQL Server 2016
SQL Server 2014
SQL Server 2012
SQL Server 2008 R2
Functional features
Business Intelligence Modernization report
SQL Server 2016
SQL Server 2014
SQL Server 2012
SQL Server 2008 R2
Functional features
Mobile Business Intelligence *
SQL Server 2016
SQL Server 2014
SQL Server 2012
SQL Server 2008 R2
Functional features
Integrated services hosted as servers
SQL Server 2016
SQL Server 2014
SQL Server 2012
SQL Server 2008 R2
Functional features
Pinning the report to Power BI
SQL Server 2016
SQL Server 2014
SQL Server 2012
SQL Server 2008 R2
Functional features
Multidimensional semantic model
SQL Server 2016
SQL Server 2014
SQL Server 2012
SQL Server 2008 R2
Functional features
Enhanced tabular BI semantic model *
SQL Server 2016
SQL Server 2014
SQL Server 2012
SQL Server 2008 R2
Functional features
Master data service *
SQL Server 2016
SQL Server 2014
SQL Server 2012
SQL Server 2008 R2
Functional features
Data quality service *
SQL Server 2016
SQL Server 2014
SQL Server 2012
SQL Server 2008 R2
Functional features
High-level analysis within a database through R Services
SQL Server 2016
SQL Server 2014
SQL Server 2012
SQL Server 2008 R2
Functional features
R query and multithreading of streaming memory *
SQL Server 2016
SQL Server 2014
SQL Server 2012
SQL Server 2008 R2
* SQL Server Enterprise Edition and developer Edition only. For more information, see the SQL Server version page.
* * use PolyBase to perform relational and non-relational data queries through the simplicity of T-SQL, which requires a Microsoft SQL Server 2016 Enterprise Edition as the header node and expands to multiple standard computing nodes.
