Last week was the 168th T-SQL Tuesday, which I hosted. The invitation is here.
I didn’t get much of a chance to check out the posts as I was at the PASS Data Community Summit, but I came home and started to work through them.
This was the 8th one I’ve hosted, which makes sense as I’ve taken over managing the party from Adam Machanic and there have been a few places I’ve had to fill in for missing hosts. In any case, here’s the roundup. I’m going in order of the comments as I see them on the blog.
Rod writes about using LAG to rewrite older cursor code that summarizes data by period. for a 30x reduction in runtime. Plus, one less cursor in the world.
Aaron Bertrand has probably done most, if not all, of the T-SQL Tuesday parties. He’s been an expert in many aspects of T-SQL and I always look forward to reading his posts. In this one, he writes about a few different problems he’s solved with different window functions on the Stack Overflow database.
Deb the DBA was in Seattle with me last week, but she found time to give us a way she gets visibility into long running processes from an audit table. In this case she wraps a few window functions inside of a set of MAX() queries of the data.
Andy Brownsword a few relative queries that perform better with window functions. A good set of examples you might use in your work.
Hugo warned me he was going to write a long post. He did. Worth a read as he delves into the execution plans behind window functions.
My own post was on a change in SQL Server 2022 that makes it easy to re-use window definitions and not have to copy/paste them.
I believe Rob Farley has done every T-SQL Tuesday, and this month is no exception. In this case, he shows how to look at temporal table data.
Chad Callihan looks at Stack Overflow and how Lead() can find gaps.
And from Twitter, I caught Barney Lawrence’s post on using FIRST_VALUE, LAST_VALUE and NULLs. I don’t often see too many people looking at first_value() and last_value(), so I liked this one.
That’s it. If you want to host in 2024, I’ve still got some spots near the end of the year. Ping me and participate in a few of the other parties on your blog.