Posts
1150
Comments
891
Trackbacks
1
T-SQL: NOLOCK and Page Splits

http://www.sqlmag.com/Articles/Index.cfm?ArticleID=92888&DisplayTab=Article

The upshot is that if a page split happens when doing a NOLOCK select, you can see the same row twice, or miss rows altogether.

The fix is to always have an ORDER BY in the SELECT.

posted on Tuesday, July 24, 2007 2:01 PM Print
Comments
No comments posted yet.

Post Comment

Title *
Name *
Email
Url
Comment *  
Please add 2 and 6 and type the answer here: