RE: Antipathy for Entity Attribute Value data models

SSC Guru

Points: 1003863

January 28, 2013 at 8:28 pm

lnardozi 61862 (1/28/2013)
I wouldn't want to change the table structure every time a requirement changes.
The DBA has better things to do, and many DBAs are not noted for their SQL programming skills.
Above all, I want my design to be flexible and maintainable by someone else but me.

Now I'm really curious. What does changing a table structure have to do with SQL programming skills?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)