Function Comparison of SQL Server database versions, SQL Server

Function Comparison of SQL Server database versions, SQL Server

Background

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:

SQL SERVER 2000

Log Transmission

Index View

SQL SERVER 2005

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

SQL SERVER 2008

Partition
Data Compression
Resource Controller
Backup Compression

SQL SERVER 2008 R2

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)

SQL SERVER 2012

AlwaysOn
Columnstore Index
Enhanced audit functions
Big Data Support

SQL SERVER 2014

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)

SQL SERVER 2016

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 ))

SQL SERVER 2017

No relevant information is available. To be supplemented.

Summary

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!