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 05, 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 @ 4:11 PM
Points: 32,810, Visits: 14,959
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 05, 2014 4:08 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 12:59 AM
Points: 933, Visits: 387
Very easy one, actually it took me 2 sec to read the options and answer.
Post #1527895
Posted Sunday, January 05, 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 05, 2014 7:13 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 1:06 AM
Points: 1,577, Visits: 694
Nice and easy -thanks Steve

Hope this helps...

Ford Fairlane
Rock and Roll Detective





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


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 3:03 AM
Points: 1,989, Visits: 1,615
Also known as "Deep Tables". I'll start calling them EAVs now to confuse my boss.
Post #1528000
Posted Monday, January 06, 2014 3:16 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 11:06 AM
Points: 12,212, Visits: 9,192
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 06, 2014 4:57 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 12:40 PM
Points: 3,316, Visits: 2,364
Good way to start the week. Thanks, Steve.


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


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 8:44 AM
Points: 1,629, Visits: 2,038
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 06, 2014 8:46 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 7:51 AM
Points: 4,246, Visits: 3,328
Very, very easy. Thanks, Steve!
Post #1528129
Posted Monday, January 06, 2014 9:50 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 6:42 PM
Points: 20,473, Visits: 14,120
Good way to start the QOTD week.



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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1528157
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse