I probably should have stated my use case. It's not a traditional data warehouse but rather a tabular model on which PowerBI reports are built for analysis/business intelligence. My...

I have to agree with Kimball.  Never update a fact table.  Only update the source of the data that the fact table was generated from and do the ETL thing...

To that end,...

I only have select permission on this table. This is a third party vendor database and I cannot update/delete/insert or create procedure/functions in this database. I am getting the...

--======================================================================================================
--      Create and populate the test table. This is not a part of the solution.
--======================================================================================================
--===== Create the test table.
   DROP...

I write functions as an "ISF", a term that MS created a very long time ago in some now extinct documentation because they never created an "Inline Scalar Function".  As...

I'm thinking that you need to be more clear on the job description that you use to hire people... a LOT more clear.  For more than just...

Well, here is a new one.

While reviewing design standards with a set of contract developers we pointed out that any object needs to be qualified with the schema of...

@ Jonathan,

Sorry... My previous post above was referring to the 10 million row run prior to your additional (@Start*@Start) optimization.  I have to try your new optimization.  I didn't look...

p.s.  I just tested the results of Jonathan's code against a 3rd party generator and it passed.

https://numbergenerator.org/numberlist/prime-numbers/1-1000000#!low=1&high=1000000&csv=nl&oddeven=&step=1&addfilters=prime_numbers-val-

Jonathan's code takes about 39 seconds for a max value of 10 million without...

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(),...