My Technical Notes

Tuesday, 10 February 2015

SQL Server NOLOCK Alternative

Instead of using `WITH (NOLOCK)` statement, you can instead set this option for all tables so you don't have to change all of your SQL:


SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;

No comments: