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.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521