T-SQL 2016 NEW FEATURES
Stolen Copied from Adam Machanic’s blog (http://sqlblog.com/blogs/adam_machanic/archive/2017/01/13/sql-server-2016-hidden-gems-resources.aspx) STRING_SPLIT https://msdn.microsoft.com/en-us/library/mt684588.aspx Aaron Bertrand’s performance tests: https://sqlperformance.com/2016/03/sql-server-2016/string-split Session Context https://msdn.microsoft.com/en-us/library/mt605113.aspx Time Zone Support sys.time_zone_info: https://msdn.microsoft.com/en-us/library/mt612790.aspx AT TIME ZONE: https://msdn.microsoft.com/en-us/library/mt612795.aspx HASHBYTES https://msdn.microsoft.com/en-us/library/ms174415.aspx Session Wait Stats https://msdn.microsoft.com/en-us/library/mt282433.aspx Live Query Statistics https://msdn.microsoft.com/en-us/library/dn831878.aspx Ability to attach to other sessions’ Live Queries! https://blogs.msdn.microsoft.com/sql_server_team/query-progress-anytime-anywhere/ Actual Query Plan Data Enhancements …