SqlHints.com

By Basavaraj Biradar

Skip to content

Performance Tuning
Sql Server Tutorial
Sql 2008
Sql 2012
Sql 2014
Sql 2016
All Articles
ABOUT BASAVARAJ

Search for:

Sql Server 2016

Below are the list of articles which I have posted on the New Features in the up-coming Sql Server 2016 based on the Sql Server CTP 3.1.

New features in SQL SERVER 2016

Native JSON Support in Sql Server 2016
DROP IF EXISTS Statement in Sql Server 2016
Compare Execution Plans in Sql Server 2016
Live Query Statistics in Sql Server 2016
DATEDIFF_BIG Function in Sql Server 2016
Difference between DATEDIFF and DATEDIFF_BIG functions in Sql Server
SESSION_CONTEXT in Sql Server 2016
GZIP COMPRESS and DECOMPRESS functions in Sql Server 2016
Temporal Tables in Sql Server 2016

Introduction to Temporal Tables and DML operations on the Temporal Table
Querying System-Versioned Temporal Table
Enabling System Versioning for an Existing Regular Table
DDL operations on the System-Versioned Temporal Table

Row level security in Sql Server 2016
Dynamic Data Masking in Sql Server 2016
STRING_SPLIT function in Sql Server 2016
Query Store in Sql Server 2016
Page allocation changes in Sql Server 2016

Share this:

Click to share on Facebook (Opens in new window)
Click to share on LinkedIn (Opens in new window)
Click to share on Twitter (Opens in new window)
Click to email a link to a friend (Opens in new window)
Click to print (Opens in new window)
Click to share on Reddit (Opens in new window)
Click to share on Tumblr (Opens in new window)
Click to share on Pocket (Opens in new window)
Click to share on Pinterest (Opens in new window)

1 thought on “Sql Server 2016”

Pingu says:

March 6, 2020 at 8:49 am

Hi, I would like to ask if I can get the scalar function copy of JSON_VALUE in sql server 2016. Thank in advance

Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Comment *

Name *

Email *

Website

Save my name, email, and website in this browser for the next time I comment.

Δ

Subscribe to Blog via Email

Email Address

Join 1,993 other subscribers

Privacy Policy

Sqlhints.com Privacy Policy

Disclaimer

This is my personal blog site. The opinions expressed here represent my own and not those of my employer. For accuracy and official reference refer to MS Books On Line and/or MSDN/TechNet. My employer do not endorse any tools, applications, books, or concepts mentioned on the blog. I have documented my personal experience on this blog.

Differences…

Varchar vs NVarchar
Varchar vs Varchar(MAX)
Char vs Varchar
Text vs Varchar(Max)
Union vs Union All
DateTime vs DateTime2
SET QUOTED_IDENTIFIER ON vs SET QUOTED_IDENTIFIER OFF
Stored Procedure vs User Defined Function
Primary Key vs Unique Key
RAISERROR vs THROW
Temporary Table vs Table Variable
Len() vs Datalength()
Sequence vs Identity
DATEDIFF vs DATEDIFF_BIG
LEFT JOIN vs LEFT OUTER JOIN
RIGHT JOIN vs RIGHT OUTER JOIN
JOIN vs INNER JOIN
LEFT OUTER JOIN vs RIGHT OUTER JOIN
SMALLDATETIME vs DATETIME

Categories

101 Performance Tuning Tips and Tricks (8)
C# (1)
Index (1)
Sql Server (199)
- CONSTRAINTS (1)
- Differences (23)
- DMVS (3)
- Errors (5)
- Exception Handling (4)
- Performance Optimization (10)
  - Common Mistakes (3)
- Scripts (29)
- Sql Server 2005 (2)
- SQL Server 2008 What's New (9)
- Sql Server 2012 (18)
  - Functions (12)
    - Conversion Functions (3)
    - Date and Time Functions (4)
    - Logical Functions (2)
    - String Functions (2)
- Sql Server 2014 (4)
  - Hekaton (3)
  - In-Memory OLTP (3)
- Sql Server 2016 (27)
- Sql Server Tutorial (8)
- Stored Procedure (2)
- System Stored Procedures (1)
- Tips/Tricks (19)
- User Defined Function (1)
- Views (1)

Archives

Archives

Sql Server Tutorial

Variables and Data Types

Working with Databases

Working with Tables

Constraints - PRIMARY KEY, UNIQUE KEY, FOREIGN KEY, CHECK, and DEFAULT

UNION AND UNION ALL

Stored Procedures

User Defined Functions

Exception Handling

New Features in Sql Server 2008

New Features in Sql Server 2012

New Features in Sql Server 2014

Recent Posts

Indexes in Sql Server – Part I June 29, 2020
How to get the Length of a String in Sql Server? February 29, 2020
How to get Day of Year from date in Sql Server September 1, 2018
Do we need to include a Clustered Index Column too in a Non-Clustered Index to make it as a Covering Index for a Query? Tip 7: Sql Server 101 Performance Tuning Tips and Tricks May 6, 2018
How to Inspect the content of a DATA PAGE or INDEX PAGE ? Tip 6: Sql Server 101 Performance Tuning Tips and Tricks May 5, 2018
How to get an Index’s Root Page, Intermediate Pages and Leaf Pages Information? Tip 5: Sql Server 101 Performance Tuning Tips and Tricks May 3, 2018
How to find the list of all Pages that belongs to a Table and Index? Tip 4: Sql Server 101 Performance Tuning Tips and Tricks April 30, 2018
Does the order of Columns in a Composite Index matters? Tip 3: Sql Server 101 Performance Tuning Tips and Tricks October 1, 2017
Evils of using function on an Index Column in the WHERE clause– Tip 2: Sql Server 101 Performance Tuning Tips and Tricks September 10, 2017
Implicit conversion an evil for Index – Tip 1: Sql Server 101 Performance Tuning Tips and Tricks September 2, 2017

Tags

Proudly powered by WordPress