How to avoid deadlocks in a table

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

JDixon-385826 SSCrazy Points: 2723 More actions · Answer 1

you can use the NOLOCK hint on select statements or SET the isolation level to read uncommitted

ps. One Orange Chip Points: 29422 More actions · Answer 2

JDixon-385826 (10/10/2009)
you can use the NOLOCK hint on select statements or SET the isolation level to read uncommitted

Beware of the consequences too!!

using NOLOCK, you'll read inconsistent data at times. If it's fine with you, you can proceed using this hint in ur select queries...

Check our for correct indexes on your tables to avoid deadlocks...

Pradeep Singh