4

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...

xhr489
  • 543
  • 2
  • 10

1 Answers1

5

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.

alroc
  • 1,534
  • 9
  • 17