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
Voice of the DBA 
16 responses to “T-SQL Tuesday #168 – Mature Window Functions”
Which time zone are the times for?
LikeLike
Which time zone are the times for?
LikeLike
UTC
LikeLike
[…] Invitation from Steve Jones. […]
LikeLike
Thanks for hosting Steve! I love the TSQL Tuesday invites, always an interesting read. One from me : https://www.sqlrod.com/post/t-sql-tuesday-168-mature-window-functions
LikeLike
Thanks Steve!
LikeLike
[…] in order, I wasn’t sure if I was going to pull this together in time. Thanks to Steve Jones (b | t ) for hosting this month’s T-SQL Tuesday. Also, thanks to Steve for making sure this blog […]
LikeLike
[…] This month’s invitation from Steve asks us to about how window functions have made life easier for us. Before we get into that let’s have a brief recap of what window functions are for those who aren’t familiar. […]
LikeLike
[…] I skipped the last two T-SQL Tuesdays. But this month, I will participate again. The monthly blog party is once more hosted by Steve Jones. His chosen topic is: Window Functions. […]
LikeLike
[…] in case I didn’t have a host, and I realized a few months ago November was blank. So I created an invitation for technical solutions using window functions, hopefully mature solutions you’ve use many […]
LikeLike
168… so that’s 14 years. Thanks for hosting Steve. https://lobsterpot.com.au/blog/2023/11/14/tuning-using-window-functions/
LikeLike
Thanks for hosting! My post is here https://callihandata.com/2023/11/14/t-sql-tuesday-168-example-using-lead/
LikeLike
[…] when rewriting queries, and an example around this would be appropriate for this month’s T-SQL Tuesday, hosted by Steve Jones (@way0utwest at […]
LikeLike
Thanks Steve! I posted on the day but have just noticed the pingback didn’t fire for my blog.
Here it is: https://barneylawrence.com/2023/11/14/t-sql-tuesday-168-first_value-last_value-and-null-handling/
LikeLike
[…] Last week was the 168th T-SQL Tuesday, which I hosted. The invitation is here. […]
LikeLike
[…] started as a simple reply to a T-SQL Tuesday prompt. It then grew to the point where I felt I had to split it. And then split it again. And, oh, there […]
LikeLike