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

Remember that deletes affect all indexes (except maybe filtered indexes) and causes a check for every FK pointing at the table.  There's some silly wide tables at one of the...

That's pretty amazing.  Now someone just needs to verify that it's actually producing the correct results using a brute force method.

Also, I've not looked into it, is there a link...

A far better way, IMHO, is to write a good SELECT in a stored procedure. 😉

What's the old saying? "Just because you can do it in Python, doesn't mean you...

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

@steve-2 Collins,

Sorry... I tried your latest code on a max value of  "just" 1 million.  I stopped it at 2 hours and 8 minutes.

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

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 to...

I also have to admit that I have no clue what something like this is supposed to be doing in T-SQL.  In another language, maybe but not in t-SQL.

(prime <<...

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 to do for...

So why are you using...

The doubled-up relational symbology isn't floating my boat on an SQL Server forum, either.

Sounds good.  You could still be affected if you copy a DATETIME2(7) into any datatype that has a lower resolution.

And, for a change, I shall be...

I tried your script with 10 million rows and it took 25 seconds with dbo.fnTally using 126 MB log file. With GENERATE_SERIES it took  it took 126 seconds using...