T-SQL Window Functions in SQL Server 2019 | Itzik David
Vložit
- čas přidán 6. 09. 2024
- Want to learn more about GroupBy’s Sponsors? Check them out below!
SolarWinds: loom.ly/ljHr3eg
Redgate: loom.ly/Q65t2z0
Data Masterminds: loom.ly/JgisLIw
SSG: 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: drive.google.c...