There are a number of real-life reporting tasks in SQL that require a 'gaps and islands' analysis. There are a number of techniques around that work, but finding ones that scale well makes for a tougher, but interesting, challenge.
2014-02-28
3,824 reads
Some SQL problems are intriguing because, just when good methods emerge and are accepted, other alternative solutions are discovered. The fun of exploring problems such as 'Gaps and Islands' is all the greater when we have a thorough test-harness to try out the alternative solutions.
2013-08-13
2,738 reads
By Steve Jones
I recently wrote about a logical diagram with Redgate Data Modeler. That was interesting,...
By Brian Kelley
After I have understood the details for a certification test (part 1), including format...
By Brian Kelley
If you're looking for particular "Black Friday" deals, here is what I've seen advertised...
Hello SSC, I hope everyone is having a happy and safe holiday season! I...
Hello, I am receiving multiple direction on deploying SQL Servers in AWS EC2. ...
Hello, I am working with a company on their database administration. I am trying...
In SQL Server 2025, what does this code return?
SELECT '1' || '0'See possible answers