/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
| | 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.
| | ctoomey.com
Downsampling Data with Postgres Window Functions | Chris Toomey
3.5 parsecs away

Travel
| |
| | bobrubocki.wordpress.com
T-SQL Tuesday - Fixing Old Problems with Shiny New Toys - Bob Rubocki
30.1 parsecs away

Travel
| I'm happy to submit this post as part of the T-SQL Tuesday series, started byAdam Machanic.I'm particularly happy because my colleague and friend, Matt Gordon, is hosting this month. Thanks, Matt!The Shiny New SQL Server Toy I want to share is temporal tables. Temporal tables are new to SQL Server with the 2016 release, and...