Answers for "Can you tell me the difference between nolock and rowlock in sql server?"https://ask.sqlservercentral.com/questions/51669/can-you-tell-me-the-difference-between-nolock-and.html
The latest answers for the question "Can you tell me the difference between nolock and rowlock in sql server?"Answer by Grant Fritcheyhttps://ask.sqlservercentral.com/answers/51671/view.html
NO_LOCK is suggesting that reads don't take out a shared lock on resources. This leads to bad data being returned by the query including missing rows and extra rows. ROW_LOCK is a way to force the system to use only row level locking over page, extent or table locking.
I don't recommend using hints like this for your queries. What it looks like is you're trying to outsmart the query optimizer to increase performance. Don't do that. Instead, look at the execution plan and understand why you're getting slow downs. It could be the code or it could be the structure.Fri, 20 Jan 2012 03:46:00 GMTGrant Fritchey