There's nothing in the original data you've posted to preserve the required order of the data to do this.  Your addition of a calculated row number doesn't cut it for...

To answer your question at the end of your original post, yes... there are other ETL tools... and, they're quite expensive and they have steep learning curves and are subject...

It probably is the "Insert Bulk" things happening.  MS tried to make code faster faster with an "improvement" called "Fast Inserts", which came about in SQL Server 2016.  It allocates...

Yeah,...

That was precisely my thought.  A fellow DBA in another company recently went through a bout with a ransom-ware.  The ransom-ware was able to track down where the...

Jeff, you want CI to be fast, because you want to get feedback quickly. This runs constantly, so it needs to be fast.

This IS NOT THE ONLY TESTING done...

They don't, actually. 😀  It's more of a visceral fearon...

One of the hardest things to do when generating test data as opposed to obfuscating production data is the non-normal situations.  I've found in my years in IT that...

no more articles for me for a short while, Steve already has one that he wants me to edit, but I've been in hospital since start of December and...

Nah thought I had one but no luck retrieving it.

I get better luck...

ha , I...

Nah thought I had one but no luck retrieving it.

I get better luck when...

ha , I hadn't...

That was my understanding, as...

Yeah, I've trialed...