GilaMonster (6/3/2011)

---

The Sch-S is the only lock a select with nolock takes, that's only blocked by an Sch-M. Need...

No. I was thinking of a more ... metaphorical ... manure.

I know salespeople who shovel manure all day on the phone. But it's not really multitasking.

GilaMonster (6/3/2011)

---

clare.xia (6/3/2011)

---

Thank you for the reply! I see the blocking from Activity Monitor, it says, the select session is 'Blocking' and the 'Insert/update/detelet' session is blocked by the session...

Elliott Whitlow (6/3/2011)

---

Sorry, I'm with G on this, NOLOCK should be used sparingly and carefully. Yes it does reduce contention, but it doesn't do it for free. The...

digdave7 (6/3/2011)

---

No to sound rude, but are you kidding me by saying Nolock is a bad idea 99% of the time....? Everyone I know has clearly shown it has huge...

I have to admit, the bit about shoveling manure while on the phone made me laugh.

Check the blocking code, see if it's got something in it that would cause it to either ignore the NoLock hint, or some part of it that is supposed to...

Jim Murphy (6/3/2011)

---

Bob - this is an old thread and...

You'll need to check to see what's blocking what. NOLOCK won't block other data reads/writes/etc. That's one of the reasons it's usually a really bad idea to use...

calvo (6/3/2011)

---

Michael Valentine Jones (6/3/2011)

---

Seriously, there are so many well known proofs for this that I feel silly getting involved, especially since this is just a classic Internet board troll,...

Okay, I'm looking at this and thinking there's a bigger issue here.

Why do you have multiple customers (different names) with the same ID number? Wouldn't customer ID alone be...

The Dixie Flatline (6/3/2011)

---

Gail: Wow....

Lynn: Good luck, because merit doesn't always triumph in this crazy world

Jason: The "Today" show carried footage of a naked...

WayneS (6/3/2011)

---

Lynn Pettis (6/3/2011)

---

Had a phone interview Thursday morning with Microsoft. It seemed to go pretty good. We'll know how good if the fly me up to Redmond...

opc.three (6/2/2011)

---

Jan Van der Eecken (6/2/2011)

---

opc.three (6/2/2011)

---

LutzM (6/2/2011)

---

To quote from a thread I've been involved:

Also, I will start to participate on the site more often. It has always been useful...

calvo (6/3/2011)

---

GSquared (6/3/2011)

---

You state that 0.3-repeats = 1/3 is an approximation, when it's actually not. It's a mathematically absolute equivalence. Anyone who knows how to do long division...