One day a year, the joke is on them. The rest of the year, it is on us. When I saw Schrödinger's equation, I thought that Microsoft was...

We had a SQL Server failover cluster for many years because we "wanted" it to be available at all times. We have many servers and the cluster turned out...

Thanks. I tried to use maintenance plans sometime around SQL 2005. I remember writing T-SQL to manually edit the XML for a plan so that it could be...

Zidar (3/11/2016)

---

BTW, solving 1X = 2X has X = 0 as a solution. There is no contradiction as it's also a solution of the original degenerate equation which is 0=0...

roger.plowman (3/11/2016)

---

rstone (3/10/2016)

---

In the logical design, the business logic might require handling missing data and reasons for missing data. Using tokens -2, -1 , 0, etc. is one way of...

ZZartin (3/10/2016)

---

If a solution...

BTW, solving 1X = 2X has X = 0 as a solution. There is no contradiction as it's also a solution of the original degenerate equation which is 0=0...

kenambrose (3/10/2016)

---

why do the same flawed arguments keep popping up?

[[If you deal with a report and want all columns via left joins, then there will be nulls. ]]

We don't know...

In the logical design, the business logic might require handling missing data and reasons for missing data. Using tokens -2, -1 , 0, etc. is one way of handling nLvl...

Sounds like the requirements are missing. Null requirements? However, if the data is really missing, each column might require custom treatment because of business requirements. In this...

The SELECT clause can arbitrarily format the results. If it is a token, I would consider it an application token, not a database token.

Back to an earlier question....

Grasshopper, if the "null" columns are stored in separate tables (6NF?), then a join (left) to build the original table would return nulls for the missing value. I see...

How about defining the null to mean that this column should exist in a separate table where there would be no record for this value? Then construct the T-SQL logic...

The debate reminds me of a quote, "I'm a mathematical optimist: I deal only with positive integers."

I'm glad I came across this discussion. 6NF with only one non-key column...

roger.plowman (3/1/2016)

---

ZZartin (3/1/2016)

---

roger.plowman (3/1/2016)

---

patrickmcginnis59 10839 (2/29/2016)

---

If you need to know why a value is missing,...