dml

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.

Oracle DML (DELETE) and the Index Clustering Factor

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(…)