Query store is a new powerful feature introduced in SQL 2016 which stores the query plan, statistics and query execution for current and past queries. You can enable it from SSMS ( 2016 and above) by clicking on the database and then on properties tab on the left side you can find query store. In
DIFFERENCE BETWEEN TWO DATES BY DATEDIFF_BIG: DATEDIFF_BIG is a new function introduced in SQL Server 2016. We will also see what is the difference between the DATEDIFF and the new DATEDIFF_BIG function. The syntax for DATEDIFF and DATEDIFF_BIG are both similar however DATEDIFF will return a int value and the DATEDIFF_BIG will return a big
Starting from SQL server 2016 we have new String split function which will help to split a string in rows. With earlier version of sql server a developer would have to create his own custom scripts to achieve this task. Syntax : STRING_SPLIT( ‘string’,’separator’). Split string will divide the input string using a separator into
