Explore >> Select a destination

You are here

 36chambers.wordpress.com
A Slice of Time: Good Use Cases - 36 Chambers - The Legendary Journeys: Execution to the max!
| | sqlserverfast.com
Plansplaining part 26 - Windows with a ranged frame - SQLServerFast
2.3 parsecs away

Travel
| | This is part twenty-six of the plansplaining series. And already the fourth episode about window functions. The first of those posts covered basic window functions; the second post focused on fast-track optimization for running aggregates, and the third post explained how the optimizer works around the lack of execution plan support for UNBOUNDED FOLLOWING. But...
| | barneylawrence.com
T-SQL Tuesday #168 - FIRST_VALUE, LAST_VALUE and NULL Handling - Barney Lawrence - A Blog
2.7 parsecs away

Travel
| | FIRST_VALUE and LAST_VALUE had limited uses when they were first released to the world back in 2012, but with the introduced of the ability to ignore nulls in SQL Server 2022 they become a lot more useful. Let's take a look at some examples of why.
| | michaelerasm.us
Window Functions in Redshift
2.4 parsecs away

Travel
| | One of the coolest things I learned about in my Redshift journey has been Window Functions. Although Window functions aren’t a novel feature and exists in other SQL databases, they are a ...
| | nocolumnname.blog
T-SQL Tuesday #86: SQL Server Bugs & Enhancement Requests - No Column Name
29.7 parsecs away

Travel
| The Good, the Bad, and the Bug-ly.