• Yeah, have to agree with this one. If you are in a situation where an ID/Value approach is going to work better, get the heck out of an RDBMS like SQL Server and into one of the other database systems like DocumentDB. As was demonstrated on that site, the desire to remove primary keys and foreign keys actually comes from a place of ignorance, not a technology driven decision.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning