Claude recommended WITH NOLOCK
April 9, 2026 at 5:16 PM
Claude recommended WITH NOLOCK
“But NOLOCK won’t hurt me if I’m using an index!”
NOLOCK is bad and you probably shouldn't use it, but every time I mention that publicly, the pushback just keeps coming. I don't know why people so firmly believe that their situation couldn't possibly be affected by bad/random data from NOLOCK.…
NOLOCK is bad and you probably shouldn't use it, but every time I mention that publicly, the pushback just keeps coming. I don't know why people so firmly believe that their situation couldn't possibly be affected by bad/random data from NOLOCK.…
“But NOLOCK won’t hurt me if I’m using an index!”
NOLOCK is bad and you probably shouldn't use it, but every time I mention that publicly, the pushback just keeps coming. I don't know why people so firmly believe that their situation couldn't possibly be affected by bad/random data from NOLOCK. Today's misconception comes from a LinkedIn commenter telling me it's safe to use if you're doing index seeks. Hoo boy.
www.brentozar.com
September 15, 2026 at 1:15 PM
“But NOLOCK won’t hurt me if I’m using an index!”
NOLOCK is bad and you probably shouldn't use it, but every time I mention that publicly, the pushback just keeps coming. I don't know why people so firmly believe that their situation couldn't possibly be affected by bad/random data from NOLOCK.…
NOLOCK is bad and you probably shouldn't use it, but every time I mention that publicly, the pushback just keeps coming. I don't know why people so firmly believe that their situation couldn't possibly be affected by bad/random data from NOLOCK.…
Over the years I’ve always used some app to prevent my Mac from locking during long running tasks like password cracking sessions or more recently agentic workflows. But they’re poorly maintained or over complicated. So I made my own. NoLock does what it says on the tin github.com/singe/NoLock
February 22, 2026 at 6:26 AM
Over the years I’ve always used some app to prevent my Mac from locking during long running tasks like password cracking sessions or more recently agentic workflows. But they’re poorly maintained or over complicated. So I made my own. NoLock does what it says on the tin github.com/singe/NoLock
Quick, someone suggest using Nolock
August 22, 2023 at 6:11 PM
Quick, someone suggest using Nolock
I'd really rather not have to keep running these demos for clients as often as I do, but here we are again. NOLOCK Is Bad And You Probably Shouldn’t Use It: www.brentozar.com/archive/2021...
NOLOCK Is Bad And You Probably Shouldn't Use It. - Brent Ozar Unlimited®
When you put NOLOCK in your query, SQL Server will: Read rows twice Skip rows altogether Show you changes that never actually got committed Let your query fail with an error This is not a bug. This…
www.brentozar.com
April 10, 2026 at 1:25 AM
I'd really rather not have to keep running these demos for clients as often as I do, but here we are again. NOLOCK Is Bad And You Probably Shouldn’t Use It: www.brentozar.com/archive/2021...
You really know you’re looking at some legacy shit when you see a WITH(NOLOCK) in a sql query
June 15, 2026 at 6:54 PM
You really know you’re looking at some legacy shit when you see a WITH(NOLOCK) in a sql query
Reading: animation of why NOLOCK counts rows twice and skips rows: blog.sqlauthority.com/2026/09/04/n...
NOLOCK: Why It Counts Some Rows Twice and Misses Others - SQL Authority with Pinal Dave
NOLOCK is not a safe performance fix, it is a decision to reduce blocking by accepting an answer that may never have been true. The whole problem is that nobody who types it thinks they are making…
blog.sqlauthority.com
September 8, 2026 at 1:25 AM
Reading: animation of why NOLOCK counts rows twice and skips rows: blog.sqlauthority.com/2026/09/04/n...
Is this in response to AC/DC’s Dirty Reads Done Dirt Cheap (NOLOCK) ?
July 6, 2025 at 3:21 PM
Is this in response to AC/DC’s Dirty Reads Done Dirt Cheap (NOLOCK) ?
You come to me on my daughters wedding day full of WITH NOLOCK
December 20, 2025 at 7:21 PM
You come to me on my daughters wedding day full of WITH NOLOCK
AI loves NOLOCK
September 15, 2026 at 1:17 PM
AI loves NOLOCK
Uh oh, where’s my mind today. SQL statement should have with (nolock) not (nocock) 🤣
January 16, 2025 at 2:54 PM
Uh oh, where’s my mind today. SQL statement should have with (nolock) not (nocock) 🤣
I added NOLOCK to every query.
January 24, 2026 at 11:56 AM
I added NOLOCK to every query.
I put NOLOCK on all the reports.
Now they are fast and occasionally fiction.
Row versioning gets you the fast part without the creative writing.
Read Committed Is Cruel by Default: my session at #PASSDataSummit West.
passdatacommunitysummit.com/west/
Now they are fast and occasionally fiction.
Row versioning gets you the fast part without the creative writing.
Read Committed Is Cruel by Default: my session at #PASSDataSummit West.
passdatacommunitysummit.com/west/
September 22, 2026 at 6:02 PM
I put NOLOCK on all the reports.
Now they are fast and occasionally fiction.
Row versioning gets you the fast part without the creative writing.
Read Committed Is Cruel by Default: my session at #PASSDataSummit West.
passdatacommunitysummit.com/west/
Now they are fast and occasionally fiction.
Row versioning gets you the fast part without the creative writing.
Read Committed Is Cruel by Default: my session at #PASSDataSummit West.
passdatacommunitysummit.com/west/
Optimist: The cup is half full
Pessimist: The cup is half empty
Database Admin:
SELECT
con.ref "Container Ref",
con.lvl "Level",
--con.type "Type",
steph.fav "Fave?"
FROM home.dbo.s_containers con with (nolock)
left join home.dbo.s_stephen steph on steph.r_id = con.r_id
WHERE
con.type = 'cup'
Pessimist: The cup is half empty
Database Admin:
SELECT
con.ref "Container Ref",
con.lvl "Level",
--con.type "Type",
steph.fav "Fave?"
FROM home.dbo.s_containers con with (nolock)
left join home.dbo.s_stephen steph on steph.r_id = con.r_id
WHERE
con.type = 'cup'
Optimist: The cup is half full
Pessimist: The cup is half empty
Animation: The cup is off-model by two pixels
Pessimist: The cup is half empty
Animation: The cup is off-model by two pixels
Optimist: The cup is half full
Pessimist: The cup is half empty
Editor: The cup feels unearned
Pessimist: The cup is half empty
Editor: The cup feels unearned
November 26, 2024 at 10:49 PM
Optimist: The cup is half full
Pessimist: The cup is half empty
Database Admin:
SELECT
con.ref "Container Ref",
con.lvl "Level",
--con.type "Type",
steph.fav "Fave?"
FROM home.dbo.s_containers con with (nolock)
left join home.dbo.s_stephen steph on steph.r_id = con.r_id
WHERE
con.type = 'cup'
Pessimist: The cup is half empty
Database Admin:
SELECT
con.ref "Container Ref",
con.lvl "Level",
--con.type "Type",
steph.fav "Fave?"
FROM home.dbo.s_containers con with (nolock)
left join home.dbo.s_stephen steph on steph.r_id = con.r_id
WHERE
con.type = 'cup'
🎧 MUSIC TO MY EARS 🎧
👏 Joe gets it.
🛑 NOLOCK abuse needs to go.
✅ In a world full of RCSI—be like Joe.
💬 Let’s build code we’re proud of (and that doesn’t read dirty data).
#SQLServer #NOLOCK #RCSI #DataIntegrity #DevLife #SQLHumor #developers #mvpbuzz
👏 Joe gets it.
🛑 NOLOCK abuse needs to go.
✅ In a world full of RCSI—be like Joe.
💬 Let’s build code we’re proud of (and that doesn’t read dirty data).
#SQLServer #NOLOCK #RCSI #DataIntegrity #DevLife #SQLHumor #developers #mvpbuzz
October 1, 2025 at 7:20 PM
🎧 MUSIC TO MY EARS 🎧
👏 Joe gets it.
🛑 NOLOCK abuse needs to go.
✅ In a world full of RCSI—be like Joe.
💬 Let’s build code we’re proud of (and that doesn’t read dirty data).
#SQLServer #NOLOCK #RCSI #DataIntegrity #DevLife #SQLHumor #developers #mvpbuzz
👏 Joe gets it.
🛑 NOLOCK abuse needs to go.
✅ In a world full of RCSI—be like Joe.
💬 Let’s build code we’re proud of (and that doesn’t read dirty data).
#SQLServer #NOLOCK #RCSI #DataIntegrity #DevLife #SQLHumor #developers #mvpbuzz
2025 SQL CHANGES WRAPPED
“You deleted 1,342 NOLOCK hints. It was your favorite thing to do!”
“You deleted 1,342 NOLOCK hints. It was your favorite thing to do!”
December 3, 2025 at 11:47 PM
2025 SQL CHANGES WRAPPED
“You deleted 1,342 NOLOCK hints. It was your favorite thing to do!”
“You deleted 1,342 NOLOCK hints. It was your favorite thing to do!”
whichever one of you left your old job and had a job that said "restore database (x) with (nolock)" should be ashamed of yourselves
April 7, 2026 at 8:10 PM
whichever one of you left your old job and had a job that said "restore database (x) with (nolock)" should be ashamed of yourselves
Folks, you gotta add some NOLOCK on that, plus READ UNCOMMITTED. It's important to use BOTH if you want optimal performance.
July 17, 2024 at 9:39 AM
Folks, you gotta add some NOLOCK on that, plus READ UNCOMMITTED. It's important to use BOTH if you want optimal performance.
Don’t miss today’s DWeb Seattle Node Meetup!
With talks by @nolock-social.bsky.social, @tinysubversions.bsky.social, and @quillmatiq.com 🤩
It’s possible to participate online, too!
Get your ticket here: lu.ma/wfoprjy7
#DWeb #DWebNode #DWebSeattle #meetup #DWebMeetup #event #Seattle
With talks by @nolock-social.bsky.social, @tinysubversions.bsky.social, and @quillmatiq.com 🤩
It’s possible to participate online, too!
Get your ticket here: lu.ma/wfoprjy7
#DWeb #DWebNode #DWebSeattle #meetup #DWebMeetup #event #Seattle
DWeb Seattle Gathering - Jun 2025 · Luma
SAVE THE DATE
Agenda:
6-6:30 Welcome
6:30 Convo 1: Sergey Shandar - https://nolock.social/ - "Cryptographic Foundation for Digital Freedom" (no math required!)…
lu.ma
June 18, 2025 at 3:40 PM
Don’t miss today’s DWeb Seattle Node Meetup!
With talks by @nolock-social.bsky.social, @tinysubversions.bsky.social, and @quillmatiq.com 🤩
It’s possible to participate online, too!
Get your ticket here: lu.ma/wfoprjy7
#DWeb #DWebNode #DWebSeattle #meetup #DWebMeetup #event #Seattle
With talks by @nolock-social.bsky.social, @tinysubversions.bsky.social, and @quillmatiq.com 🤩
It’s possible to participate online, too!
Get your ticket here: lu.ma/wfoprjy7
#DWeb #DWebNode #DWebSeattle #meetup #DWebMeetup #event #Seattle
Smith & Wesson just released three new revolvers that don't have "the lock:" the Models 10, 19, and 36.
Prediction: in 20 years or so, collectors will start to actively seek out the "lock" guns.
#smithwesson #smithandwesson #smithandwessonpartner #nolock #38special #357magnum #revolver #revolvers
Prediction: in 20 years or so, collectors will start to actively seek out the "lock" guns.
#smithwesson #smithandwesson #smithandwessonpartner #nolock #38special #357magnum #revolver #revolvers
January 16, 2025 at 2:29 PM
Smith & Wesson just released three new revolvers that don't have "the lock:" the Models 10, 19, and 36.
Prediction: in 20 years or so, collectors will start to actively seek out the "lock" guns.
#smithwesson #smithandwesson #smithandwessonpartner #nolock #38special #357magnum #revolver #revolvers
Prediction: in 20 years or so, collectors will start to actively seek out the "lock" guns.
#smithwesson #smithandwesson #smithandwessonpartner #nolock #38special #357magnum #revolver #revolvers
No, Accelerated Database Recovery Doesn’t Fix NOLOCK.
I have never seen a T-SQL feature that people love as much as NOLOCK. I keep thinking I've written enough blog posts about it, but a client came up with a new one: We use SQL Server 2022's Accelerated Database Recovery, which keeps copies of…
I have never seen a T-SQL feature that people love as much as NOLOCK. I keep thinking I've written enough blog posts about it, but a client came up with a new one: We use SQL Server 2022's Accelerated Database Recovery, which keeps copies of…
No, Accelerated Database Recovery Doesn’t Fix NOLOCK.
I have never seen a T-SQL feature that people love as much as NOLOCK. I keep thinking I've written enough blog posts about it, but a client came up with a new one: We use SQL Server 2022's Accelerated Database Recovery, which keeps copies of versions inside the table. Plus, we don't use transactions - our inserts, updates, and deletes are done one table at a time, and your demos always have transactions in them, so we're not affected.
www.brentozar.com
September 10, 2025 at 1:17 PM
No, Accelerated Database Recovery Doesn’t Fix NOLOCK.
I have never seen a T-SQL feature that people love as much as NOLOCK. I keep thinking I've written enough blog posts about it, but a client came up with a new one: We use SQL Server 2022's Accelerated Database Recovery, which keeps copies of…
I have never seen a T-SQL feature that people love as much as NOLOCK. I keep thinking I've written enough blog posts about it, but a client came up with a new one: We use SQL Server 2022's Accelerated Database Recovery, which keeps copies of…
August 16, 2025 at 9:01 AM
Getting #fucked when I wear the #fufuclip results in hours of leaking💦 /cum💦/orgasm💦. Here's a quick demo removing it (after) and putting it back on. (To me the straps are necessary) Unlike🔏 #cagedcock there is #nolock so it's an alt version of #chastity -another 🔥🔥🔥device in our toybox
June 14, 2025 at 8:59 AM
Getting #fucked when I wear the #fufuclip results in hours of leaking💦 /cum💦/orgasm💦. Here's a quick demo removing it (after) and putting it back on. (To me the straps are necessary) Unlike🔏 #cagedcock there is #nolock so it's an alt version of #chastity -another 🔥🔥🔥device in our toybox
"But we'll use NOLOCK queries only..."
September 8, 2023 at 7:14 AM
"But we'll use NOLOCK queries only..."