SQL SERVER – Observation: ROWLOCK Hint and Slow Performance

(Pinal Dave) During my recent Comprehensive Database Performance Health Check Developer showed me a slow query which used ROWLOCK hint. The common understanding is that with the help of ROWLOCK hint SQL Server only locks a single row which eventually leads to performance but in their case, it was ac