T-SQL Window Functions in SQL Server 2019 | Itzik David

Published: 04 November 2021
on channel: GroupBy

713

Want to learn more about GroupBy’s Sponsors? Check them out below!

SolarWinds: https://loom.ly/ljHr3eg
Redgate: https://loom.ly/Q65t2z0
Data Masterminds: https://loom.ly/JgisLIw
SSG: https://loom.ly/MotcEjE

I am also Oracle DBA so when SQL Server 2012 supported window functions I publish before everyone first article about SQL Server and windows function in SQL Server magazine .

In this session you will become an expert who can use window functions to solve T-SQL query problems. Replace slow cursors and self-joins with queries that are easy to write and perform better. I will covers the latest performance enhancements through SQL Server 2019.

Window functions are useful in analytics and business intelligence reporting. Once you begin using window functions, such as ROW_NUMBER and LAG, you will discover many ways to use them. You will approach SQL Server queries in a different way, thinking about sets of data instead of individual rows. Your queries will run faster and easier to maintain, and enhance .

Download Session Materials here: https://drive.google.com/drive/folder...

On this page of the site you can watch the video online T-SQL Window Functions in SQL Server 2019 | Itzik David with a duration of hours minute second in good quality, which was uploaded by the user GroupBy 04 November 2021, share the link with friends and acquaintances, this video has already been watched 713 times on youtube and it was liked by 14 viewers. Enjoy your viewing!

148,253

1.2K