october, 2021

26oct6:00 pm7:30 pmVirtual EventT-SQL Window Functions in SQL Server 2019David Yitzhak

Event Details

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 .

JOIN THIS SESSION HERE: https://groupby.org/attend

more

Virtual Event Details

Event has already taken place!

Time

(Tuesday) 6:00 pm - 7:30 pm UTC