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.

2.33 (3)

2021-04-16 (first published: )

10,459 reads

Technical Article

Generating sequential numbers - the fast way

It is often necessary to generate a table with sequential numbers, up to a specified upper limit N. For small N, a simple INSERT in a WHILE loop will do. But, for large N, that solution becomes too slow. This script presents a different approach. It generates sequential numbers from the binary representation of N, […]

4.5 (2)

2004-12-30 (first published: )

596 reads

Blogs

VMware & SQL Server 823-824 alerts

By

We’ve been tracking a weird state with SQL Server virtual machines on VMware and...

Daily Coping 18 May 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Storage Field Day 23 – SIOS

By

I am thrilled to have been a part of this year’s Storage Field Day...

Read the latest Blogs

Forums

Search not working???

By jbalbo

Hi, We have a user that is not an administrator that says when they...

sql server enterprise edition or standard

By juliava

Hello, I was looking over the Edition specifications, and Standard is capped at 128...

Quick Question on 2019 to older version?

By oogibah

A client of ours is upgrading their database to SQL Server 2019. The edition...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers