Lock Escalation |

SELECT *
FROM Posts
WHERE Tags IN ('Lock Escalation')

abr

2016

Back To Basics, Lock Escalation in SQL Server

Today at work we’ve had a very common request, no big deal, just a couple of UPDATE which affect tens of thousands of rows in a couple of tables independently. I can say I’ve been there, done that…

SELECT * FROM Posts WHERE Tags IN ('Lock Escalation')

Back To Basics, Lock Escalation in SQL Server

SELECT *
FROM Posts
WHERE Tags IN ('Lock Escalation')