Function Comparison of SQL Server database versions, SQL Server

Source: Internet
Author: User

Function Comparison of SQL Server database versions, SQL Server


At the Data Amp Conference held today, Microsoft stressed to developers how Data affects their applications and services, along with several small news announcements. This free online seminar not only demonstrates the future of machine learning, but also introduces SQL Server 2017, facial recognition service APIs, and Azure Analysis Services. Obviously, SQL Server 2017 will become the next key for developers to bet on machine learning. It supports Python (Python/R) and supports data-intensive computing. Microsoft began to work hard on machine learning.

Database ranking

Microsoft SQL Server ranked by 9.03 this month as the largest database in the top 20 by database-Engines.

Function Comparison of Different Versions

Since I first came into contact with SQL server 2000, I have already experienced so many versions. The following describes the new functions of each version:


Log Transmission

Index View


Database image
(Only SQL Server 2005 Enterprise Edition SP1 and later support asynchronous database images .)
Online indexing
Database Snapshot
Failover Cluster


Data Compression
Resource Controller
Backup Compression


The R2 flag indicates that this is an intermediate version of SQL Server, rather than a master version. Currently, many of my clients use this version, and the performance is stable. Although there are few new features:
The data center edition is added, and supports a maximum of 256 cores.
Unicode Compression

(Provides a simple compression solution for Unicode storage. using Unicode compression, you can reduce space occupation by Unicode characters)


Columnstore Index
Enhanced audit functions
Big Data Support


This version has many new effects and is very useful.

Memory Optimization table
Backup Encryption
New base estimation Design
AlwaysOn enhancements
Latency persistence (specify some or all transactions as delayed persistent transactions to shorten latency)
Partition switching and index generation
Column storage Index
SSD is used to expand the buffer pool.
Incremental statistics
Resource Controller Enhancement
(-- Previously, only CPU and memory can be controlled, and I/O can be controlled from 2014)


Always Encrypted)
JSON support
Multiple TempDB database files
Query Store
(I went to Microsoft training a few days ago and talked about quite good functions. It can help solve the problem of parameter sniffing .)
Supported R languages
Live Quer y St at ist ics
(You can see the execution plan overhead more clearly (Water Stream ))


No relevant information is available. To be supplemented.


In general, SQL server is getting better and better. I hope more and more people will learn more about it. If you have any other questions, please feel free to discuss it.

The above is a comparison of the functions of SQL Server database versions introduced by xiaobian. I hope it will be helpful to you. If you have any questions, please leave a message and I will reply to you in a timely manner. Thank you very much for your support for the help House website!

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.