Sean Lange (6/5/2014)

---

It took a couple weeks of data analysis and collection but I was finally able to prove that it was all because of dirty reads. We then started...

TomThomson (6/5/2014)

---

SQLRNNR (6/5/2014)

---

Grant Fritchey (6/5/2014)

---

Please, please, please, bestester behavior, no piling on of any kind (or I'll delete the posts and I can do that, BWA-HA-HA-HA, THE POWER!, ahem, where...

Is this of any help?

http://sqlperformance.com/2013/11/t-sql-queries/single-tx-deadlock

george sibbald (6/5/2014)

---

TheSQLGuru (6/5/2014)

---

george sibbald (6/5/2014)

---

I have an app where the vendor recommends (nay insists) setting maxdop to 1 and cost threshold to 15, go figure.........

Is Dynamics AX a microsoft...

SQL is delicious (6/5/2014)

---

LOL...because I questioned some of their coding practices and brought to light the fact that they're not following our standards when they promised they were, I have...

david.alcock (6/5/2014)

---

Thanks for the replies guys.

No CXPACKET waits whatsoever, tiny little IO waits but that is about all. Its not the first time I have come across 'best' practices...

hisakimatama (6/5/2014)

---

Argh. I too suffer under the burden of working with code littered with NOLOCK :(.

The vendor software

...

"It's vital to our operations!", and that was that. ...

Looks like SSC might have a PHP compromise.

Various pages try to download a junk php file to my machine now. It started just yesterday.

Who do we contact about that?

Grant Fritchey (6/5/2014)

---

SQLRNNR (6/5/2014)

---

Grant Fritchey (6/5/2014)

---

Please, please, please, bestester behavior, no piling on of any kind (or I'll delete the posts and I can do that, BWA-HA-HA-HA, THE POWER!, ahem,...

Lynn Pettis (6/5/2014)

---

Grant Fritchey (6/5/2014)

---

Please, please, please, bestester behavior, no piling on of any kind (or I'll delete the posts and I can do that, BWA-HA-HA-HA, THE POWER!, ahem, where...

SQL is delicious (6/5/2014)

---

SQLRNNR (6/5/2014)

Great. I love that excuse "It's the way we/I have always done it".

That kind of excuse right there shows a base incompetence. Everything he...

Grant Fritchey (6/5/2014)

---

Please, please, please, bestester behavior, no piling on of any kind (or I'll delete the posts and I can do that, BWA-HA-HA-HA, THE POWER!, ahem, where was I),...

SQL is delicious (6/5/2014)

---

Koen Verbeeck (6/5/2014)

---

SQL is delicious (6/5/2014)

---

On the subject of WITH (NOLOCK) in code being a pet peeve....

I was going over an SSIS template with a consultant the...

trotsalot

GilaMonster (6/5/2014)

---

Koen Verbeeck (6/5/2014)

---

Yes, you assign the result of the expression...