scarydba.com
Undocumented Virtual Column: %%lockres% - Grant Fritchey
One of my development teams needed a mechanism for identifying the value of a key that was part of a lock (don’t ask). I’d never tried doing that before. Obviously if you hit the DMV sys.dm_tran_locks you can see the hash of the key in the resource_description column. But how to pull the value back. After some […]
Grant Fritchey