patternsqlMinor
Skipped rows or rows read multiple times with NOLOCK
Viewed 0 times
skippedrowsreadwithmultiplenolocktimes
Problem
Is it possible to stimulate a situation where rows either get skipped or get read multiple times in a select statement? E.g. the way we can cause a blocking or a deadlock...
Solution
Gail Shaw posted a demo of how to do so quite a while ago. It works by inducing row movement by increasing the size of the row over time. No inserts or deletes, just updates to existing records.
Context
StackExchange Database Administrators Q#281406, answer score: 5
Revisions (0)
No revisions yet.