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, Live Class Season Pass PLUS Lab VM or Mastering Query Tuning, or log in if you already shelled out the cash.