Advanced SQL window function quiz

Re:Advanced SQL window function quiz by atwebb on Thursday February 08, 2018 @09:47PM (#16337530)

Not always the case, especially with columnstore indexes and batch mode, even traditionally, rownum/lead/lag/ordering functions are extremely handy along with aggregates. I can't actually think of many, result set/batch, scenarios that would be better replicated in code, not counting the speed on extra delivery (every row for a sum) and possible miscalculations. Add in the ability to index views and some other things for specific scenarios, then again, I'm mostly MSSQL and lack in other offerings, or knowing where they might lack.

Also, the site is blocked for me currently...

[ Parent | on HN ]

Re:Advanced SQL window function quiz by nickpeterson on Thursday February 08, 2018 @10:22PM (#16337683)

I think often conversations about this are really people talking past each other. If you work in the enterprise, and spend tons of time dealing with 'business logic' and bespoke systems, using SQL seems preferable because many of your headaches come from systems being out of sync, or reports showing different values. Databases represent a way to guard against a lot of problems that tend to occur in that environment. It's only when you branch into other realms of development where it starts to feel really backwards and archaic.

[ Parent | on HN ]

Re:Advanced SQL window function quiz by Fins on Friday February 09, 2018 @02:35AM (#16338566)

But is getting correct results reliably really "backwards and archaic", or does it only seem so because it is not the latest shiny toy with a trendiest name? (edited: spelling)

[ Parent | on HN ]