SQL Tuning Golf, anyone?
Golf is one of the very few sports where the goal is the lowest possible score. Code golf is about solving a given algorithm using the fewest possible characters. It can be very fun indeed to play code golf, also in SQL. But for real…
Game Of Life in MODEL clause – revisited
Long time ago I blogged about Conways’s Game of Life in a MODEL clause, which also made it into Chapter 6 of my book Practical Oracle SQL. Today Samuel Nitsche applied this approach to solve Day 11 of Advent of Code 2020 (follow Sam’s blog for…
Midsummer Midsomer SQL Winner
In June I launched the Midsummer Midsomer Murder SQL Challenge and Book Competition. I promised to announce a winner within a week of the deadline – that was yesterday, so I’m afraid I’m one day late, sorry about that but better late than never 😇….
Midsummer Midsomer Murder SQL Challenge and Book Competition
It’s getting close to Midsummer, where in Denmark we traditionally burn witches on Saint John’s Eve. If we misspell it slightly to Midsomer, we have the Midsomer Murders series with loads of dead. So let’s have a little murderous SQL challenge for Midsummer to give…
SQL Magic Squares – or Why the Optimizer does not like Magic
A long-time player at the Oracle Dev Gym tried his hand at generating Magic Squares using SQL. When he attempted to tune his statement a bit, he was surprised that it didn’t go a little faster as expected, rather it went from 2 minutes to…