spam Like Dislike

When and When Not To Use NOLOCK

published 641 days, 14 hours, 18 minutes ago posted by matthewpomarmatthewpomar 651 days, 12 hours, 29 minutes ago
Wednesday, December 29, 2021 1:17:53 PM GMT Sunday, December 19, 2021 3:06:48 PM GMT

To NOLOCK or Not to NOLOCK... That is the question. Lots of developers who don't fully understand the requirements of their application or how NOLOCK works will indiscriminately add NOLOCK to all of the SQL queries. But doing so isn't always the best decision.

Brent Ozar describes some times when it is beneficial to use NOLOCK and times where it isn't the right choice.

After visiting this story, if you enjoyed it, please show the author some love by coming back and clicking Like button and leaving a comment.

category: SQL Server | clicked: 1 | | source: www.brentozar.com | show counter code
tags: MS SQL, Performance

No comments yet, be the first one to post comment.

To post your comment please login or signup

Welcome SQL Server Developers!

Are you a SQL Server developer or interested in becoming one? DeveloperSites is here to help you find the most interesting, freshest SQL Server developer stories for you to sharpen your skills as a seasoned SQL Server developer or help you find resources that will help you become a SQL Server developer.

Here you will find the latest SQL Server blog posts, articles, books and more. The best stories are voted up by our growing SQL Server developer community.

Signup for free and join the DeveloperSites community today!