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.
2021-04-16 (first published: 2004-11-22)
10,948 reads
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, […]
2004-12-30 (first published: 2003-11-24)
600 reads
This a modification to the script given by Preethi.It generates prime numbers to the upper bound you specify.Modifications are using following facts from algebra:1. All prime numbers greater than 3 can be written in the form 6 * X +/- 1.2. Instead of checking the module for ALL numbers
2003-09-25
365 reads
Today I have uploaded SQL Server Quickie #46 to YouTube. This time I’m talking...
By Brian Kelley
If you haven’t already signed up, on November 29, 2023, at 11 AM Eastern...
Picture this, you’re happily backing up your database to a Azure blob storage until...
hi so i have a really old application that is used to process data...
I'm experiencing difficulties opening a custom report created in Visual Studio 2019 using Microsoft...
hi xyz.bat this is called from microsoft sheduler. the contenct of .bat is followng....
Ask SSC