Gaps

Article

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

The SQL of Gaps and Islands in Sequences

by Additional Articles

SimpleTalk

Gaps

Article

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

Read the latest Blogs

Visit the forum

Question of the Day

Estimated Rows

I have two calls to the GENERATE_SERIES TVF in this code:

SELECT   TOP 10 gs.value
FROM     GENERATE_SERIES(1, 10) AS gs
ORDER BY NEWID ()
OPTION (RECOMPILE);
go
DECLARE @a int = 10;
SELECT   TOP (@a) gs.value
FROM     GENERATE_SERIES(1, @a) AS gs
ORDER BY NEWID ()
OPTION (RECOMPILE);

In the actual query plans, what is the estimated number of rows for each batch in SQL Server 2022?

See possible answers

Gaps

Calculating Gaps Between Overlapping Time Intervals in SQL

The SQL of Gaps and Islands in Sequences

Blogs

SQL Server Alerts

Prompt AI helping with Auditing

From Data Custodian to Innovation Catalyst: The Evolving Role of the CDO

Forums

Create an HTML Report on the Status of SQL Server Agent Jobs

Collation errors...what is best way to deal with it?

Was the index created or not?

Question of the Day

Estimated Rows