I was just exploring
UPDLOCK hint in SQL-Server 2008 and I found it is very useful in avoiding certain deadlock scenarios. There are always some side effects when using these types of lock hints but I could not find any for this one.
So what happens if I use it in all my
update queries? I am not talking about
update. How will it affect me negatively?