Refactor with Locking Hints (ROWLOCK/NOLOCK)

jvlake

I would like to be able to refactor with locking hints...

i.e.

UPDATE mytable WITH (ROWLOCK)
SELECT ID FROM mytable WITH (NOLOCK)

This would be a good extra refactoring and take the count up from only 11 refactors


I'm aware that some folk don't agree that locking hints are needed, but I'm using this tool in a work envirionment and the use of hints is mandated.

---

Also converting x.id = y.id to inner join syntax as a refactor

Brian Donahue

Thanks for your forum post. I have logged an enhancement request (SSR-881) for locking hints.