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)
598 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
364 reads
By Steve Jones
There’s a video of Bill Gates taking a drive in an autonomous car around...
It is common to see high worker count issue on the production server and...
This is part of a series of new job blog posts. You can find...
Hi Experts, What is meant by PAGELATCH_UP waittype ? what does it trying to...
Looking for suggestions\examples of how to update a SP that the table used changes...
Hi Experts, Yesterday, we ran a program and it has processed 1500 records in...
Ask SSC