This will shock most but I've had to climb this hill many times in the past.  These are "durations".  Don't store them as date and time datatypes.  Before I can...

I've got to ask, as well.  Why the requirement of doing the transfer with (ugh!) XML?  That is, quite possibly, the absolute slowest and "pipe heavy" method that you could...

Sorry... posted in the wrong spot.  Deleted this post.

UPDATE:

Like the rest of the world, I had been duped into thinking that Random GUIDs are bad.  The two most cited reasons are that they're 4 times bigger than an...

Has anyone done this on servers with numerous applications accessing them? How do you handle applications slowing down due to the loss of indexes? And how does Always On...

Ah.... sorry.... What do you want the output to look like for the test data you provided?  I ask because you have multiple clients and you've not identified what you...

Heh... you really should trying running your own code before you post it. 😉

Converting Integers that look like dates...

To summarize what Thom has so correctly stated, it's "DEI", which stands for "Declared Entity Integrity" and, along with "DRI" (Declared Referential Integrity), it forms the backbone of what properly...

I almost forgot about that Jeff.  I've always wanted to contribute more but I always feel like someone else has already done it better.  Besides, in the example with...

Without the queries that caused the CPU to stick to the ceiling, there's really no way to help here.

I will tell you that if you didn't do your inserts in...

\

If you'd like to learn more about it, there's a whole article on it.

https://www.sqlservercentral.com/articles/tally-oh-an-improved-sql-8k-%e2%80%9ccsv-splitter%e2%80%9d-function

If you'd post some readily consumable data, that would help us help you with an answer.  See the first link in my signature line below for one of many ways...

You posted in a 2019 forum. 😉

Thank you for the feedback, Lidou