Competition: What’s your favorite Redgate tool? Enter now.

Refactor with Locking Hints (ROWLOCK/NOLOCK)

jvlakejvlake Posts: 7
edited April 8, 2010 11:39AM in SQL Refactor Previous Versions
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

Comments

Sign In or Register to comment.