Microsoft Data Platform Group Birmingham - Thursday 9th June 2022 @ 13:00 BST.
Speaker:
Kevin Feasel
Title: A Slice of Time: Window Functions in SQL Server
Window functions are a powerful technique for analyzing data in SQL Server. In this session, we will understand when to use a window function like ROW_NUMBER() or LAG(), including specific use cases.
We will understand:
* The performance implications of window functions
* Performance tuning of queries with window functions
* Using window functions to make certain classes of queries faster
* Performance implications of having multiple windows in a single query.
This talk will also review some of the limitations in SQL Server's implementation of window functions and how to work around many of these.
Agenda:
12.45 - 13:00 : Setup and Join
13:00 - 13:05 : Open Lobby and Introductions
13:05 - 14:00 : A Slice of Time: Window Functions in SQL Server
Venue:
Wherever you have access to Computer or Smart Device! This session will be online only!
Other Details:
*** Please note registration on MeetUp is required to gain access to the Teams remote link!***
You MUST RSVP to this event to gain access to the remote link! Please contact us on Twitter or via email if you are having any issues joining and we'll do everything we can to help.
***Update: Event link to follow soon!***
Event Organiser Contact Details:
If you need any further details or have any requests for this or future Data Platform Group events, please get in touch.
Contact:
Email: [masked]
Twitter: @MSDataGroupBrum (https://twitter.com/MSDataGroupBrum)
Sponsors:
Purple Frog Systems
Power BI Sentinel