Explore >> Select a destination

You are here

 michaelerasm.us
Window Functions in Redshift
| | ctoomey.com
Downsampling Data with Postgres Window Functions | Chris Toomey
3.1 parsecs away

Travel
| |
| | 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...
| | andreabergia.com
Introduction to SQL Window Functions / 1 ยท Andrea Bergia's Website
2.3 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.
| | dbanuggets.com
T-SQL Tuesday 177: Managing DatabaseCode - Deepthi Goguri's SQL Server Blog
16.0 parsecs away

Travel
| Thank you Mala for hosting T-SQL Tuesday for August month. Mala asked us to write about the Database version control and what tools we use to manage our database code. Please find the original invite here. Earlier in my career as a DBA, the database code was managed with comments in the code to know...