Lock (In)Compatability

If you want to go ‘nuts’ on locks and I mean not the SM-way .. learning this can also be painful as well…

https://learn.microsoft.com/en-us/sql/relational-databases/sql-server-transaction-locking-and-row-versioning-guide?view=sql-server-ver17

And here are the old red an new blue matrix, both have 22 columns, I think they are the same. If you have frustrations blue is probably a better color to cool the DBA down.

The new one.

The old one.

Some explanations, if you are using Erik Darling sp_BlitzLock you can see these X (actual lock perhaps a KEY) an IX (perhaps on a PAGE).