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
  • 827
  • 11
  • 30

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,694
  • 11
  • 20