Jeff Moden (1/30/2013)

---

It is a bit wicked, though. How are you handling similar but different attribute names for the same thing? For example, in address related data, you...

Jeff Moden (1/28/2013)

---

Heh... wait a minute now. Are you saying that you work in an environment where developers can make physical table changes directly in the production environment without...

long_shanks64

IT should not be the center of the universe. Most of your questions should be answered by "Not IT" with a proper EAV model in place. Access and...

long_shanks64 (1/23/2013)

---

What percentage of a typical organisations attributes are not known at initial design time? Typically less than 5% - in which case why compromise a physical design for the...

I think Eric's example demonstrates the strength of an EAV design..you can add new attributes via data and not table structure.

David, I see from the responses that your...

The Anchor Modeling approach is interesting, but I imagine that an environment where there are many different entities each with hundreds or maybe even thousands of attributes are added over...

Having used EAV designs for well over a decade, I still haven't seen a good alternative for data driven systems that provides the flexibility of an EAV in dealing with...

Thanks all...I resisted the temptation and allowed the rollback to finish. It did take 20-25% longer (~10hours) to rollback than the elapsed time prior to killing the query (~8...