Refactor with Locking Hints (ROWLOCK/NOLOCK)
jvlake
Posts: 7
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
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
Comments