New answers tagged transaction
The statement is atomic and is its own transaction, so no, there is no value in surrounding it with BEGIN TRANSACTION; / COMMIT TRANSACTION;. It will either succeed in whole or fail in whole.
(Converting my comment to an answer. I don't know if this is definitive, but it makes sense to me. If you can prove it wrong, let me know in the comments.) The row versions aren't actually required to complete a write operation; they're only required by readers that come along and need those versions of the rows. If they need them. If tempdb runs out of ...
Top 50 recent answers are included