I have developed two additional versions of the function and incorporated Microsoft's GENERATE_SEQUENCE in a test script.

The code for dbo.GENERATE_SEQUENCE is provided in the script article. It is written as...

The measurements for the code above includes the table allocation as well as the WHILE loop and the final SELECT?  In the code above the STATISTICS TIME, IO only...

Another interesting thing is that you simulated the manual process of crossing out numbers on paper by deleting them.

It's a bloody shame that the use of GENERATE_SERIES() defeats minimal...

It's basically a primes sieve, but instead of ticking...

Despite its appearance, this process seems slow at first glance; however, it actually exhibits impressive speed, computing all prime numbers below one million in just two seconds.

SET...

It's coming... According to the way they handled things like GENERATE_SERIES(), etc,...

Ok... I'm a little gobsmacked... I ran your code with zero changes and it's riddled with syntax errors and,yet, it ran without error.

What is the following supposed...

As one query

DECLARE @maxNumber INT = 1000;

WITH BitArray AS (
    SELECT [value] AS Id, 1 AS Bit FROM generate_series(1, (@maxNumber - 1) /...

Yes but the whole...

including p.N%6 IN(1, 2) It does increase the performance a bit, so I would argue it is appropriate. It changes the number of prime candidates from n/2...

The amount of computation could be reduced by restricting the list of divisors to just the prime numbers already found that are <= SQRT(candidate). The problem is that the...

Hmmm  imo the  issue of mathematical appropriateness of n = 6q + r is debatable.  I found this link which describes it a little.  Without complete analysis it...

From my testing SQL Server's GENERATE_SERIES is efficient and well-optimized. It's not surprising it performers better than user defined functions as it is implemented in the native code...

That's the article which had shaped my low expectations.  Good to know it's been improved.  It's also interesting Jonathan used GENERATE_SERIES in place of the non-itvf method of...

I installed SQL Server 2022 today and changed my version to use GENERATE_SERIES. I also amended Steve Collins algorithm to use it and remove all the multiplications by "*2+1" as...