Red Gate forums :: View topic - Refactor with Locking Hints (ROWLOCK/NOLOCK)
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Refactor 1
SQL Refactor 1 forum

Refactor with Locking Hints (ROWLOCK/NOLOCK)

Search in SQL Refactor 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
jvlake



Joined: 07 Apr 2010
Posts: 5

PostPosted: Wed Apr 07, 2010 12:22 am    Post subject: Refactor with Locking Hints (ROWLOCK/NOLOCK) Reply with quote

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
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6669

PostPosted: Thu Apr 08, 2010 4:39 pm    Post subject: Reply with quote

Thanks for your forum post. I have logged an enhancement request (SSR-881) for locking hints.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group