3.2 Using Batches to Do a Lot of Work Without Blocking

Let’s say we need to do a lot of work: Delete all of the Users whose Location = ‘London, United Kingdom’ Plus delete all of their rows in related tables: Badges, Comments, Posts, and Votes We could try doing it in one giant transaction, but that’s going to take out exclusive locks on a lot…

To access this incredible, amazing content, you gotta get Live Class Season Pass or Mastering Query Tuning, or log in if you already shelled out the cash.

Let’s say we need to do a lot of work: Delete all of the Users whose Location = ‘London, United Kingdom’ Plus delete all of their rows in related tables: Badges, Comments, Posts, and Votes We could try doing it in one giant transaction, but that’s going to take out exclusive locks on a lot...
To access this incredible, amazing content, you gotta get Live Class Season Pass or Mastering Query Tuning, or log in if you already shelled out the cash.
Menu