On Sat, Aug 16, 2008 at 2:19 PM, Decibel! <decibel(at)decibel(dot)org> wrote:
> You need to trim down your EAV table.
Egads! I'd say completely get rid of this beast and redesign it
according to valid relational concepts.
This post pretty much explains the whole issue with EAV:
http://groups.google.com/group/microsoft.public.sqlserver.programming/browse_thread/thread/df5bb99b3eaadfa9/6a160e5027ce3a80?lnk=st&q=eav#6a160e5027ce3a80
EAV is evil. Period.