ApexSQL Log is showing UPDATE records as DELETE/INSERT pairs for clustered index value. Can this information be shown as UPDATE record?
Unfortunately, no, seeing the DELETE/INSERT pair is completely normal – this is what SQL Server actually does when you change a value that’s part of a clustered index. The reason for this is that each change to clustered index really implies changing the position of the row in the physical layout of the table itself which in turn implies that it has to be deleted from its old position (page/slot) and then inserted into the new position (page/slot). Hence the DELETE/INSERT pair is logged instead of a simple UPDATE.
