Wow, how have I never heard of this? I'm having trouble wrapping my head around this, could you perhaps give an easy "real-world" example of how it might be used?

Currently, we're locking at the record level in one of our apps but we use a Column called "SessionLockID" or something. It'd be nice to get rid of this methodology if possible.