I could possibly see the value if multiple apps were writing to the database. But we have a single app in control of this table, and it can easily...

Thank you very much for your quick and detailed response.

So you are suggesting that the X locks are for different parts of the PK index of the table...