Could someone give me some guidance on when I should use WITH (NOLOCK)
as opposed to SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
What are the pros/cons of each? Are there any unintended consequences you've run into using one as opposed to the other?
See Question&Answers more detail:os