Split, Sort, Collapse: how SQL Server survives an overlapping unique update
How SQL Server shifts a whole unique column by +1 without ever creating a duplicate using Split/Sort/Collapse.
How SQL Server shifts a whole unique column by +1 without ever creating a duplicate using Split/Sort/Collapse.
As a consultant working for customers, I’m often in the situation that I have an answer to a problem, but the recommended solution cannot be implemented due to some restrictions. E.g. the recommendation would be to adjust the code, but that is not feasible. In such cases you are forced to try to help without code changes. Recently I was…