Day: January 12, 2015

Lock Escalations in the Isolation Level SERIALIZABLE

01/12/2015 01/12/2015 / By Klaus Aschenbrenner / SQLServer / 2 Comments

In today’s blog posting I will talk about how you can have Lock Escalations in the isolation level SERIALIZABLE, and how they can be avoided. I have already blogged back in February 2014 about the basic concept of Lock Escalations and why they are needed in SQL Server. So please go back to this blog …

Lock Escalations in the Isolation Level SERIALIZABLE + read more

SQLpassion Performance Tuning Training Plan – Signup

Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.