ZZartin (2/29/2016)

---

roger.plowman (2/29/2016)

---

I still don't see why relational tables can't have records for TBD, N/A, and UNK.

This A) gets rid of nulls, which are just messy to code for and...

I still don't see why relational tables can't have records for TBD, N/A, and UNK.

This A) gets rid of nulls, which are just messy to code for and B) doesn't...

j-1064772 (2/26/2016)

---

roger.plowman (2/26/2016)

---

j-1064772 (2/26/2016)

---

Otherwise how do you publish the information if no field can be left NULL ? Real life cannot be constrained by database design requirements. Life is full...

j-1064772 (2/26/2016)

---

Otherwise how do you publish the information if no field can be left NULL ? Real life cannot be constrained by database design requirements. Life is full of uncertainties...

I'm in the camp of "Nullable columns are a dumb idea" with one glaring exception. If you have a "notes" field that is NORMALLY left empty AND defined as [n]varchar(max)...

Extended properties are essential for good documentation, yes, but if you're adding them to the database itself (after the fact) you have a world of hurt just waiting for you.

Why...

So the only real use of the term "CROSS JOIN" vs the older seperation of two tables by a comma is simply to reassure the reader that the cross join...

Password managers have their own dangers, they are NOT something you should recommend. One compromise of a user's system and EVERY SINGLE SITE they log into is compromised--and they won't...

below86 (2/5/2016)

---

roger.plowman (2/5/2016)

---

below86 (2/5/2016)

---

I would like to live in your fantasy world. It...

below86 (2/5/2016)

---

I would like to live in your fantasy world. It sounds so...

Phil Parkin (2/5/2016)

---

roger.plowman (2/5/2016)

---

Eric M Russell (2/3/2016)

---

As a DBA, if I get a 2am call that a critical application is down, because a select in a stored procedure is missing...

Eric M Russell (2/3/2016)

---

As a DBA, if I get a 2am call that a critical application is down, because a select in a stored procedure is missing a join operator,...

Andy Warren (2/2/2016)

---

Steve, I wonder if calling it a design mistake is correct, or fair. It's a different product with a different purpose. I like the ability to make small...

Phil Parkin (2/2/2016)

---

roger.plowman (2/2/2016)

---

Phil Parkin (2/1/2016)

---

roger.plowman (2/1/2016)

---

below86 (2/1/2016)

---

Here is the reason I would NEVER EVER want...

Phil Parkin (2/1/2016)

---

roger.plowman (2/1/2016)

---

below86 (2/1/2016)

---

Here is the reason I would NEVER EVER want to be on...