(I wasn't disagreeing with you, just using your point as a starting...

Lynn Pettis (1/31/2010)

---

David Portas (1/31/2010)

---

Matt Miller (#4) (1/31/2010)When I say X is NULL, it means I know nothing about it: I don't even know if it's something that can HAVE...

David Portas (1/31/2010)

---

Matt Miller (#4) (1/30/2010)

---

NULL isn't a value. Remember - it's a state, representing a lack of known value (which interestingly enough is what your flag idea was...

David Portas (1/30/2010)

---

Jeff Moden (1/30/2010)

---

None the less, the way nulls have been defined in SQL Server as a default is that they are treated as unknown and X=X where X...

It's a matter of implementation, I suppose. I've had the opposite experience from what Davd reports: whenever someone implements something with a value to represent "invalid data" or a...

Lynn Pettis (1/29/2010)

---

Matt Miller (#4) (1/29/2010)

---

keep in mind that getting the same results stops being true when those inner joins turn into outer joins.

Jack - what's non-ANSI compliant in Query...

keep in mind that getting the same results stops being true when those inner joins turn into outer joins.

Jack - what's non-ANSI compliant in Query 1? I'm running a...

Bill Gates-870674 (1/28/2010)

---

OK Lynn.

So You are asking to emphasis more on understanding business and getting industrial functional knowledge. Along with your techinical skills, you must have a good understanding of...

I don't know if this helps at all, but we are currently testing a "mixed approach". The approach entails SQLCLR procedures making calls to an External Rules engine. ...

"Hi I'm Matt Miller, and I've screwed up before". ...

dma-669038 (1/22/2010)

---

All the DBAs who are men in my team are gaming almost on a daily basis. Personally i think stress esp for DBAs is due to too much thinking/alertness...

Adam Machanic (1/22/2010)

---

Matt Miller (#4) (1/21/2010)

---

I'm curious how we go about proving one way or another. It's fairly fast, but it sure seems to be acting like it's waiting...

I'm curious how we go about proving one way or another. It's fairly fast, but it...

TheSQLGuru (1/18/2010)

---

I fall squarely in the use the right tool for the job camp. And if I decide that a GOTO is the right tool for the job, that...

TheSQLGuru (1/18/2010)

---

Matt Miller (#4) (1/17/2010)

---

I didn't.

I'm saying that most OO languages these days would tend...