😀

Thanks ALZDBA, You are spot-on. It is rather a balancing act between development, performance needs, and database design. Compromises need to be made at both ends to get...

Awesome Matt! I don't take anyone's view as being absolute. There always seems to be a mitigating circumstance that happens somewhere. You know the proverbial "Murphy's Law" kind...

Good points guys. Primary Keys IMO should always be non-nullable. This is an absolute must. FK's, eh... not so much depending upon the usage of the table....

Thanks for the quick reply Matt. I see your point, but isn't that type of validation best handled on the front-end?