NOLOCK is a query hint developers often turn to in order to keep their queries from getting blocked. That may be effective in some cases.
In this video, we examine the upsides and downsides of using NOLOCK, with a little help from Quentin Tarantino.
If you’ve got other ideas when it’s good — or bad — to use NOLOCK, let us know in the comments.
Thanks for watching!
- Using the Same Column Twice in a SQL UPDATE Statement September 13, 2018
- T-SQL Tuesday #96: Three Pivot Points November 14, 2017
- Why You Can’t Use ROW_NUMBER() In Your WHERE Clause September 28, 2017
- Three Magic Letters to Make Your DBA Like You More September 21, 2017
- Stop Using PRINT to Track Query Progress September 12, 2017