Goce Smilevski


SQLServerCentral Article

An Efficient Set-based Solution for Islands and Gaps

After reading a recent article on identifying islands and gaps in sequential numbers, one of our readers was inspired to develop a more efficient solution for fragmented data. New Author Goce Smilevski brings us his solution and supporting data to show how this can be done better.

(3)

You rated this post out of 5. Change rating

2021-04-16 (first published: )

11,357 reads

Blogs

T-SQL Tuesday #200 - I Bet It's Bad if I See...

By

T-SQL Tuesday is a monthly blog party hosted by a different community member each...

Azure – HorizonDB

By

As Open Source – PostgreSQL and AI is a growing and powerful DB system,...

A New Chapter: Why I Made the Move from Dayforce to ESO

By

A New Chapter: Why I Made the Move from Dayforce to ESO Over the...

Read the latest Blogs

Forums

How Clustering can be Used as a Preprocessing Technique for Classification in Azure Machine Learning

By Dinesh Asanka

Comments posted to this topic are about the item How Clustering can be Used...

Moving the Error Log

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Moving the Error Log

A Security and AI Fail

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A Security and AI Fail

Visit the forum

Question of the Day

Moving the Error Log

How can I change the location in which the SQL Server error log is written in SQL Server 2025?

See possible answers