>Delayed reaction here as I go clean out old messages. What does 'SWAG' mean?
>

Scientific Wild-Assed Guess or Silly Wild-Assed Guess, at the option of the recipient to translate. Usually, means that there's some intuitive indication that this might be an answer, but I wouldn't bet a beer on it.

>>My SWAG is not that it's checking for changes, but rather that when it's used exclusively, the whole table is locked, but when it's shared, it has to lock one record at a time, which would take longer.