I read this question, decided it was a bit weird because where clauses don't evaluate to anything and concluded that it must be asking what truth-value/values the expression in the...

Jeff Moden (4/20/2010)

---

The pun on "bad" doesn't really work in...

crookj (4/20/2010)

---

Tom.Thomson (4/19/2010)

---

Cafe Ritazza (smells worse. Do you have it...

Well, I used to be a Scot. But I got married so now I'm a slave. 😀

The first...

Cafe Ritazza (smells worse. Do you have it in right-pondland?)

David Walker-278941 (4/19/2010)

---

This article, like many discussions of Cross Apply and Outer Apply, says "APPLY is named after the process of applying a set of input rows to a table-valued...

I haven't been hit by it yet, but I'm supposed to be flyin from ACE to MAN next...

Lynn Pettis (4/19/2010)

---

anthony_merriwether (4/19/2010)

---

This is for all of you who are perturbed with the postings that you are seeing. I have read your replies and feel that you are all...

Paul, that's wonderful. Please keep producinjg comments like that one.

Jeff Moden (4/18/2010)

---

I still can't believe that someone needs a 70 column primary key. Without actually understanding the table at hand, I believe that some normalization would be in...

Paul White NZ (4/18/2010)

---

In defence of HashBytes...

HashBytes can use the MD2, MD4, MD5, SHA, or SHA1 hashing algorithms.

I would probably use HashBytes using SHA1 (salted for the truly paranoid), since...

Jeff Moden (4/19/2010)

---

BTW... the real reason why I'm asking the above question is that it may explain why so many people have questions like "I deleted a table and only...

Jeff Moden (4/19/2010)

---

I didn't mean for it to sound harsh on my part. Let me ask though simply because I lead a life sheltered by large batch jobs where...

Jeff Moden (4/18/2010)

---

Right now, I'm testing with the FULL recovery model. I'll follow that up with the SIMPLE model but most folks don't run SIMPLE recovery on databases they...