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
Which time zone are the times for?
LikeLike
Which time zone are the times for?
LikeLike
UTC
LikeLike
Pingback: T-SQL Tuesday #168 – Mature Window Functions – T-SQL Tuesday
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
Pingback: T-SQL Tuesday #168 – Window Functions – Deb the DBA
Pingback: T-SQL Tuesday #168 – Mature Window Functions – Andy Brownsword
Pingback: Plansplaining part 23 / T-SQL Tuesday 168 - Window functions - SQLServerFast
Pingback: T-SQL Tuesday #168–Using Window Functions | Voice of the DBA
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
Pingback: Query Tuning via Window Function – Curated SQL
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
Pingback: T-SQL Tuesday #168–Roundup | Voice of the DBA
Pingback: Plansplaining part 28 - The curious case of the missing FIRST_VALUE function - SQLServerFast