<% dim ModuleName,InfoID,ChannelShortName,CorrelativeArticle,InstallDir,ChannelDir,Keyword,PageTitle,ArticleIntro,Articlecontent Keyword=stripHTML("数据库,万方") PageTitle=stripHTML("Learning SQL Server 2016") ArticleIntro=stripHTML("Learning SQL Server 2016,ThispageisanattempttolistallthenewfeaturesinSQLServer2016andgivedataprofess") Articlecontent=stripHTML("

  This page is an attempt to list all the new features in SQL Server 2016 and …") ModuleName = stripHTML("classical") InfoID = stripHTML("203336") ChannelShortName=stripHTML("文章") InstallDir=stripHTML("http://www.77169.com/") ChannelDir=stripHTML("classical") %> Learning SQL Server 2016 - 华盟网 - http://www.77169.com  <% Function stripHTML(strHTML) 'Strips the HTML tags from strHTML Dim objRegExp, strOutput Set objRegExp = New Regexp objRegExp.IgnoreCase = True objRegExp.Global = True objRegExp.Pattern = "<.+?>" 'Replace all HTML tag matches with the empty string strOutput = objRegExp.Replace(strHTML, "") 'Replace all < and > with < and > strOutput = Replace(strOutput, "<", "<") strOutput = Replace(strOutput, ">", ">") strOutput = Replace(strOutput,Chr(34),Chr(39)) stripHTML = strOutput 'Return the value of strOutput Set objRegExp = Nothing End Function %> "> 
您现在的位置: 华盟网 >> 知识库 >> 操作系统 >> Linux >> 新手入门 >> 正文

Learning SQL Server 2016

2015/11/16 作者:不祥 来源: 互联网
导读 <% if len(ArticleIntro)<3 then Response.Write Articlecontent 'Response.Write "Articlecontent" else Response.Write ArticleIntro 'Response.Write "ArticleIntro" end if %>

This page is an attempt to list all the new features in SQL Server 2016 and give data professionals a place to begin learning about what has changed. Each of the topics below is described with a link to another page that contains various resources that can help you learn more about that particular topic.

If you find errors or ommissions for the topic list, please leave a comment on this article. If any of the specific topics has broken or missing links, please leave a comment on those pages.

The title for each section is the link to another page.

Columnstore Indexes

SQL Server 2016 has new improvements for columnstore indexes including updateable nonclustered columnstore indexes, columnstore indexes on in-memory tables, and many more.

In-Memory OLTP

Improvements have been made in SQL Server 2016 to the In-Memory OLTP tables and reducing limitations.

Live Query Statistics

Live Query Statistics allow you to view the live query statistics of an active query, providing real time insights.

Query Store

The Query Store is designed to give DBAs insight into query plan choice and help with performance issues.

Temporal Tables

A temporal table is a table that provides a view of the data of a table at a point in time. This allows you to look at the historical view of a table at a point in time in the past.

Backup to Azure

The Backup to Azure feature is designed to allow you to take a backup of your on-premises database directly to Azure blog storage.

Managed Backup

The Managed Backup feature is designed to automate your backups to Azure Blob Storage.

Multiple TempDB Files

In SQL Server 2016, we have the ability to setup multiple tempdb files directly from setup.


The FOR JSON clause can be added to a SELECT statement to return JSON formatted results to client applications.

Always Encrypted

Always Encrypted is useful when the client cannot trust the server and wants to ensure only encrypted data is stored and manipulated on the server.


Polybase allows a SQL Server use to access data stored in Hadoop using T-SQL.

Stretch Database

Stretch Database allows you to store parts of a table in the Azure SQL Database for archival purposes. The database automatically moves rows meeting some criteria to Azure and offloads computation to the Azure cloud.

Row-Level Security

Row-Level Security (RLS) has been available in Azure for a few months, but it is coming to SQL Server 2016. This allows you us define a function that can be used as criteria in queries for determining if users can access particular rows of data.

Dynamic Data Masking

Dynamic Data Masking is a feature in SQL Server 2016 that is designed to return a custom mask of information for sensitve data in columns.

本文数据库(mssql)相关术语:熊片数据库 mssql数据库 oracle数据库 pubmed数据库 access数据库 万方数据库

                  微信群名称:华盟-黑白之道         华盟--黑白之道⑦QQ群: 9430885

  • 上一篇文章:

  • 下一篇文章: