andrew gothard (6/9/2014)

---

Andrew Kernodle (6/5/2014)

---

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

The vendor software we use at my current company has NOLOCK...

Koen Verbeeck (6/6/2014)

---

patrickmcginnis59 10839 (6/6/2014)

---

Koen Verbeeck (6/6/2014)

---

gbritton1 (6/6/2014)

---

Koen Verbeeck (6/6/2014)

---

TomThomson (6/6/2014)

---

Just a couple of examples: A British colleague who held an A-level in math and a bachelor's in business...

Koen Verbeeck (6/6/2014)

---

gbritton1 (6/6/2014)

---

Koen Verbeeck (6/6/2014)

---

TomThomson (6/6/2014)

---

Just a couple of examples: A British colleague who held an A-level in math and a bachelor's in business swore you could, in...

GilaMonster (6/6/2014)

---

patrickmcginnis59 10839 (6/5/2014)

---

I'm going to be honest with you, as far as 2014 memory optimized tables(?) go, I don't know what standard behavior even is. I sure hope it...

Grant Fritchey (6/5/2014)

---

patrickmcginnis59 10839 (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!,...

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),...

That I can agree...

"Best practices" is pretty much a key phrase that helps gather recommendations together regarding...

Rudyx - the Doctor (6/3/2014)

---

A great list discussion - my 3 cents:

- table variables need to be depracated with extreme prejudice

- SSMS generated code (IMAX screen width anybody...

I notice a small difference between myself and others where I work, in inserts and selects, I like each column on its own line, but I regularily deal with lines...

Steve Jones - SSC Editor (5/23/2014)

---

chrisn-585491 (5/23/2014)

---

DO IT!

As for email, you need to tweak it anyway. I currently get two emails to the same email address, everyday. Figure this out,...

aajavaherian (5/22/2014)

---

I don't understand the reply with the code and if it results in 0. I just want to know how to use placeholders in my code above in...

david.john.gilligan (5/22/2014)

---

Quite interesting...are they creating temporary databases and users programatically with very restricted rights to that and only that database and assures they cannot elevate or access any other database...

http://sqlfiddle.com/%5B/URL%5D does much the same thing...

This is a Microsoft SQL Server forum, and doubt you'll get much DBI help.

None the less, if you look at the man page for DBI, you'll see an example of...