The theoretical problem with nulls is well-documented, effectively degrading any table that allows them to something less than a relation.  That said, even Codd, the pioneer of relational databases, recognized...

ZZartin (6/1/2016)

---

Dennis Q Miller (6/1/2016)

---

Stacey Decker (10/30/2014)

---

I agree, why allow two values to mean the same thing? I handle this by allowing optional fields such as AddressLine2 to be NULL...

Stacey Decker (10/30/2014)

---

I agree, why allow two values to mean the same thing? I handle this by allowing optional fields such as AddressLine2 to be NULL and then implement a...

hakim.ali (12/27/2012)

---

Dennis Q Miller (12/27/2012)

---

The "doubling" you experienced is symptomatic of adding a clustered index with a 50 percent fill-factor to a table with little free space. When the...

hakim.ali (12/24/2012)

---

Mr. hoek (12/24/2012)

---

But why does the table allocation 'double' when adding a clustered index?

The only explanation I can think of, is that SQL server has the information 'twice' in...

To say a table "is" a clustered index is specious, at best. I suppose you might approximate truth by saying the table "is" the leaf nodes of a clustered...

Fact tables should have a clustered index on an ever-increasing identity column. That facilitates LOAD performance by eliminating page splits. It also reduces the need for free space, so...

Every relation has a PRIMARY KEY and therefore, so must a table if we expect it to represent a relation. The purpose is to assure that each row is distinct...

MattieNH (5/9/2008)

---

Steve,

Thanks for responding, I probably should have opened a new topic. I'm not arguing about the need for a primary key, and I realize that it has to...

Hi all,

So often we confuse logical requirements with those of physical design.

I firmly believe that in logical design, every table must have a primary key. But that...

Hi all,

So often we confuse logical requirements with those of physical design.

I firmly believe that in logical design, every table must have a primary key. But that...