开发者

SQL Server: Are physical operations rolled back after ROLLBACK?

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)

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜