Goce Smilevski

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: )

598 reads

Technical Article

Optimized prime number generator

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


364 reads


Autonomous Driving Around London


There’s a video of Bill Gates taking a drive in an autonomous car around...

Best way to monitor high worker thread on SQL Server


It is common to see high worker count issue on the production server and...

New Job -> Week 3 -> Creating Alerts


This is part of a series of new job blog posts. You can find...

Read the latest Blogs


multiple PAGELATCH_UP waits on data file

By bobrooney.81

Hi Experts, What is meant by PAGELATCH_UP waittype ? what does it trying to...

dynamic update to SP

By Bruin

Looking for suggestions\examples of how to update a SP that the table used changes...

slow processing

By bobrooney.81

Hi Experts, Yesterday, we ran a program and it has processed 1500 records in...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers