Fancy a decent Compatibility Matrix?

  2. 1 minutes

Have you ever taken a look at Microsoft’s published compatibility matrix for SQL Server lock compatibility? If you have, then I don’t need to tell you that it sucks in a very big way.

Have no fear, I have painstakingly redrawn at better one (via PowerPoint no less!) and am making available to you totally free of charge as a lovely PDF slide found via here… Why you ask? Because I love you all!

Lock compatibility matrix v1
Not too bad for version 1 eh!

If you have any comments for improvements OR find any errors then please don’t hesitate to contact me (you know how!).

SQL Concurrency
previous: When should you use NOLOCK?
next: SQLBits 9 Slidedeck for READPAST & Furious