Back

Explore Courses Blog Tutorials Interview Questions
0 votes
1 view
in SQL by (20.3k points)

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?

1 Answer

0 votes
by (40.4k points)

Both of them are the same thing If you are using the set transaction isolation level statement, then it will be applied to all the tables in the connection, Therefore, if you need a nolock on one or two tables use that; otherwise, use the other.

Welcome to Intellipaat Community. Get your technical queries answered by top developers!

28.4k questions

29.7k answers

500 comments

94.2k users

Browse Categories

...