Does the new locking optimization make batching unnecessary?

6 votes

4 answers

1095 views

sql-server azure-sql-database locking lock-escalation sql-server-2025

                          Optimized Locking (2025-05-19)  makes it sound like batching  would be unnecessary if I were to, for example, try to delete 20 thousand rows from a million row table in one statement (DELETE FROM foo WHERE Status = 1). Is that true?

                        

Asked by Mark Freeman (2293 rep)

Jun 23, 2025, 03:31 PM
Last activity: Jun 25, 2025, 12:18 PM

Does the new locking optimization make batching unnecessary?

Related Questions