Also, it's still using Inner Join for all the joins so if there is no allergy the query will presumably return no row rather than a row with a NULL...

I forgot one:

5) risks of using backup log to append a log backup to an existing file containing log backups instead of always creating a new backup file for each...

GilaMonster (9/16/2011)

---

I suspect this got lost in all the 'helping Grant abuse SQL' posts...

Another request:

I'm bunking tonight and starting the rewrite of my rather old (and second-ever) article Managing Transaction...

Bifigliano

A good question. I'm not at all sure about the answer though. After answering with my best guess (and getting a probably undeserved point because I picked what...

Steve Jones - SSC Editor (9/15/2011)

---

Please let's not have quotes of every post that counts down from 95, 94, 93.

I'm going out of town for a few days. I'm hoping...

DugyC (9/15/2011)

---

Great question, but I got it wrong because I jumped too quick and didn't properly think it through.

I deliberately chose 1222 because it "Returns the resources and types of...

Jeff Moden (9/14/2011)

---

On that note, the developers at work use some sort of Visual Studio "wizard" to make tables... all character based columns are automatically set to NVARCHAR(4000). When...

Jeera (and Mirchi)

wolfkillj (9/14/2011)

---

Tom.Thomson (9/14/2011)

---

Since a correct answer wasn't possible (I though "insert into cuss2 returns an error" and "insert into cuss2 doesn't return an error" couldn't both be ticked, that would...

CELKO (9/11/2011)

---

The quote is not exactly right, but Nick Wirth once said that a "good programming language makes good programming easier and bad programming harder. But it cannot cause the...

A good question marred for some by a typo.

But it was a typo that added to the fun - it was perfectly sensible to try to reason about what the...

mtillman-921105 (9/14/2011)

---

Grant Fritchey (9/14/2011)

---

You combined Jeff & FLOAT. You're going to get the lecture now about the evils of the DECIMAL data type. I'm sorry, but you've brought this on...

Grant Fritchey (9/14/2011)

---

Changing the topic for a moment, I'd like to beg some ideas from the group, again.

I'm tasked with writing another article. This one is all about the scary,...

Ninja's_RGR'us (9/14/2011)

---

Jan Van der Eecken (9/14/2011)

---

Darn, Johan beat me to it...

Congrats from me too, Jeff!

Well deserved! And enjoy your free trip to the summit! May the Chops be with you...