Practical Uses and Optimisation of New T-SQL Features in Microsoft SQL Server 2012
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.