A
agent_008_nl
Guest
Only on the question of should the primary unique key be natural or artificial. Whenever I made a recommendation it was the artificial key. Some thoughts: www.techrepublic.com/.../10-tips-for-choosing-between-a-surrogate-and-natural-primary-key Moreover this artificial key is not a sequence but a guid (you can assign the guid on whatever client-type without a connection to the appserver etc.). I would prefer the sequential guid www.codeproject.com/.../GUIDs-as-fast-primary-keys-under-multiple-database www.siepman.nl/.../ID-Sequential-Guid-COMB-Vs-Int-Identity-using-Entity-Framework.aspx as it gives beter performance, but we would need the clustered index in the rdbms for that. -- Kind regards, Stefan Houtzager Houtzager ICT consultancy & development www.linkedin.com/in/stefanhoutzager
Continue reading...
Continue reading...