Just to add in my 2p-worth (after running into similar issues), if you're doing the insert/update/delete as separate transactions, have you considered using a MERGE statement to do everything in one go?