Database and Analytics

T11 Exploring T-SQL Enhancements: Windowing and More


1:30pm - 2:45pm

Level: Intermediate

Leonard Lobel



Sleek Technologies, Inc.

This informative and demo-packed session will quickly get you up to speed on SQL Server's powerful windowing features. You'll learn how to leverage windowing with the OVER clause to calculate running and sliding aggregations, row lookups, and percentiles based on rank. You'll also explore other T-SQL enhancements, including new functions (all 22 of them), improved error handling with THROW, server-side paging with OFFSET/FETCH NEXT, sequence generators, and metadata discovery techniques. If you want to learn about windowing and other T-SQL enhancements in SQL Server, you won't want to miss this session.

You will learn:

  • About the windowing features in SQL Server
  • About the 22 new T-SQL functions, including 8 new analytic windowing functions
  • About explore OVER, THROW, OFFSET, and metadata discovery