/explore

Click through on any links that interest you or select the planets on the right to continue exploring the Outer Web.
You are here

 michaelerasm.us
Window Functions in Redshift
| | sqlserverfast.com
Plansplaining part 26 - Windows with a ranged frame - SQLServerFast
2.9 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...
| | 36chambers.wordpress.com
A Slice of Time: Good Use Cases - 36 Chambers - The Legendary Journeys: Execution to the max!
2.5 parsecs away

Travel
| | This is part seven in a series on window functions in SQL Server. The Road So Far To this point, we've looked at five classes of window function in SQL Server. I've given you a couple of solid use cases, but for the most part, we've focused on what the classes of window functions are....
| | andreabergia.com
Introduction to SQL Window Functions / 1 ยท Andrea Bergia's Website
2.5 parsecs away

Travel
| | Window functions are an extremely powerful powerful part of the SQL 2003 standard, supported by most modern releases of databases such as Oracle 8+, Postgres 9.1+, SQL Server 2005+ and others. Sadly neither SQLLite or MySql seem to support them yet, but if you are working with a database where they are available, do use them: they can make your life a lot easier. Generally, with window functions, you can write simpler and faster code than you would without.
| | littlekendra.com
Erik Darling and Kendra Little Rate SQL Server Perf Tuning Techniques
45.4 parsecs away

Travel
| Kendra Little writes and draws comics about SQL Server, Data Platforms, and Database DevOps.