Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

James Serra's Blog

James is a big data and data warehousing technology specialist at Microsoft. He is a thought leader in the use and application of Big Data technologies, including MPP solutions involving hybrid technologies of relational data, Hadoop, and private and public cloud. Previously he was an independent consultant working as a Data Warehouse/Business Intelligence architect and developer. He is a prior SQL Server MVP with over 30 years of IT experience. James is a popular blogger (JamesSerra.com) and speaker, having presented at dozens of PASS events including the PASS Business Analytics conference and the PASS Summit. He is the author of the book “Reporting with Microsoft SQL Server 2012”. He received a Bachelor of Science degree in Computer Engineering from the University of Nevada-Las Vegas.

SQL Server 2012 (“Denali”): T-SQL Enhancements

SQL Server 2012 has a number of new T-SQL features.  Listed below are all of the new features, along with the best links I have found that describe each feature:

WITH RESULT SETS, OFFSET AND FETCH, THROW, SEQUENCE: See New T-SQL Features in SQL Server 2012 and SQL Server 2012-DENALI-whats new in T-SQL

FORCESEEK and FORCESCAN: See FORCESEEK and FORCESCAN – New enhancements with Table hints in SQL Server Denali CTP3

Conversion functions: See New Built-in Functions in SQL Server 2012 Denali and SQL Server 2012 – new conversion functions

Date and time functions: See New Date and Time Functions in SQL Server 2012

Logical functions: See New Logical Functions in SQL Server 2012 (IIF and CHOOSE)

String functions: See CONCAT() string function–SQL Server 2012 and SQL Server v.Next (Denali) : CTP3 T-SQL Enhancements : FORMAT()

Analytic functions: See The new Analytic functions in SQL Server 2012

More info:

Video The T-SQL Cookbook: What’s Cool in Microsoft SQL Server 2008 R2 and New in SQL Server Code-Named Denali”

Programmability Enhancements (Database Engine)

Comments

Leave a comment on the original post [www.jamesserra.com, opens in a new window]

Loading comments...