Product has been added to your cart.

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.

  1. Home
  3. SQL Server Training Classes by Brent Ozar
  5. Mastering Query Tuning
  7. 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.
Menu