Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

EAV Expand / Collapse
Author
Message
Posted Sunday, January 5, 2014 4:04 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 12:34 PM
Points: 31,181, Visits: 15,626
Comments posted to this topic are about the item EAV






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1527894
Posted Sunday, January 5, 2014 4:08 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 12:27 AM
Points: 1,321, Visits: 632
Very easy one, actually it took me 2 sec to read the options and answer.
Post #1527895
Posted Sunday, January 5, 2014 6:31 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, March 20, 2014 6:00 AM
Points: 588, Visits: 276
Gracias por la más fácil Steve

+1
Post #1527898
Posted Sunday, January 5, 2014 7:13 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 7:21 PM
Points: 1,762, Visits: 766
Nice and easy -thanks Steve

Hope this helps...

Ford Fairlane
Rock and Roll Detective





Post #1527953
Posted Monday, January 6, 2014 2:29 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 6:53 AM
Points: 2,166, Visits: 1,752
Also known as "Deep Tables". I'll start calling them EAVs now to confuse my boss.
Post #1528000
Posted Monday, January 6, 2014 3:16 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:40 AM
Points: 13,275, Visits: 11,059
Easy one, thanks.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1528011
Posted Monday, January 6, 2014 4:57 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 1:09 PM
Points: 4,231, Visits: 3,665
Good way to start the week. Thanks, Steve.


Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions
Post #1528040
Posted Monday, January 6, 2014 8:28 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, October 20, 2014 4:25 PM
Points: 1,853, Visits: 2,186
Thanks for the question on EAVs. They are a very controversial topic. I have designed databases that used them for PART of the schema. However, I always use them with some reluctance.

In particular, I used them when I did the data model for LAN Desk for Intel. It was a product that, among other things, had to track the configuration information for systems on the network. Hardware and software had to be modeled, as well as the relationships between components. It got kind of messy when you had to store information about daughter cards mounted on the motherboard that were being used as RAM drives! (Just to name one example.) Plus, the database had to account for all the possible ways that technology would add in new kinds of things to put in a computer, new attributes that you didn't even envision, and new ways for things to be related. It was fun, but it took a lot of time to explain to the developers.

[Fixed typo.]


Please don't go. The drones need you. They look up to you.
Connect to me on LinkedIn
Post #1528118
Posted Monday, January 6, 2014 8:46 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Wednesday, October 1, 2014 10:48 AM
Points: 4,126, Visits: 3,427
Very, very easy. Thanks, Steve!
Post #1528129
Posted Monday, January 6, 2014 9:50 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 10:17 PM
Points: 17,817, Visits: 15,744
Good way to start the QOTD week.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1528157
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse