Optimized Locking part 2: Lock After Qualification
No Comments
SQL Server 2025 introduced Optimized Locking. Not one, but two features, sharing a single marketing name. Lock After Qualification (LAQ) One of these two features is Lock After Qualification (LAQ). This feature avoids the scenario where a delete or update is blocked by a locked row that would not qualify. But, like any good thing, there is a price. This video shows the feature, explains how it works, and shows some of the potentially undesired side effects. More of me? Was this useful to you? Do you want to learn more from me? You can click here to see an…
Read More
