HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

Skipped rows or rows read multiple times with NOLOCK

Submitted by: @import:stackexchange-dba··
0
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.