It’s time for T-SQL Tuesday and I’m hosting this month. I usually do one a year, just because I can and being responsible for a month keeps me engaged in the party.

This month my invitation is on Window functions and is described below.

If you’d like to host T-SQL Tuesday, let me know. I have lots of openings in 2024 and I’m looking for someone with a blog, some creativity, and an idea for a technical topic that you’d like to see other people write about.

Mature Window Functions

We’ve had window functions in SQL Server for a decade now, since SQL Server 2012.

This month I’m asking you to write on how window functions have made your life easier. A few ideas for you:

• What problems have you solved with a window function? Bonus points for lead/lag/first_value/last_value
• Have you used the SQL Server 2022 enhancements in any queries?
• How has performance improved for you with a window function
• Draw a picture of a window with a spatial function – more extra points

Give us some specifics, with real world problems. Obfuscate the data, at least if you have my name in your dev system, but help others understand how they might solve a complex aggregate using a Window function. The more specific examples, the more others might get help from one of the posts.

The Rules

Not many rules, but a few of them.

• Post between 00:00:00 and 23:59:59 on 2023-11-14
• Include the logo above in your post
• Link that logo to this post
• Leave me a trackback or comment on this post (double check if you have this automated)
• Post you URL on Twitter, LinkedIn, etc. with the hashtag #tsql2sday
• Have fun