Practical Uses and Optimisation of New T-SQL Features in Microsoft SQL Server 2012

Download this episode

Download Video

Description

SQL Server 2012 brings a whole bag of powerful new T-SQL features that will make your T-SQL development a breeze. How did you do your paging so far? Got mad at the lack of proper support? Not any longer! Now there's OFFSET to help you with that. Remember when you had to do those running totals with CLR, sub-queries, quirky updates or cursors? Enter the new WINDOWING FUNCTIONS that offer a simple solution to that problem and a bunch of new possibilities. Ever had identity problems? Let me show you the power of new SEQUENCES! But wait, there's more! We'll even take a look at the upgraded ERROR HANDLING, new FORMATTING and CONVERTING functions, awesome METADATA DISCOVERY and more. This session focuses on practical uses of the awesome new features in SQL Server 2012 that that allow you to improve your existing solutions.
For more information, check out this course on Microsoft Virtual Academy:

Day:

3

Code:

DBI305

Embed

Format

Available formats for this video:

Actual format may change based on video formats available and browser capability.

    The Discussion

    Comments closed

    Comments have been closed since this content was published more than 30 days ago, but if you'd like to send us feedback you can Contact Us.