naveen awasthi

naveen awasthi

  • 1.4k
  • 17
  • 16.9k

when to use with(nolock) and with(rowLock) in sql server

Oct 10 2014 3:18 AM
when to use with(nolock) and with(rowLock) in sql server 2008.
 and what is the advantage and disadvantages of using this.
and what impact on performance  of application of using this.
 
i am getting error :- transaction process id was deadlocked on lock resources with another process  and has been detect as deadlock victiom

Answers (2)