What are the effects of ROLLBACK TRANSACTION
on physical ordering开发者_JS百科 of data in pages? Are physical operations also rolled back when ROLLBACK
is addressed?
Based on these articles by Paul Randal and SQL Fool I'd say "no": on-disk layouts are not rolled back
These are about page splits, but a page split will affect physical ordering of the clustered index (not logical ordering though).
Note: there is never any guaranteed order without an ORDER BY (just in case)
精彩评论