• RonKyle (9/3/2015)


    Not to sound harsh, but have you ever done any real, complex database development work? It certainly sounds like you haven't.

    I have done real, complex database development, both in OLTP and OLAP. Can't even imagine where that comment came from, or what it has to do with the topic at hand. As I've said, my reasons for being insistent on this point is that I've had to clean up more than one mess because these basic rules weren't followed. I've seen the results when the rules aren't followed. And generally when I've had a chance to talk with those who would omit them, they don't seem to have a good understanding of database design, or have a mistaken view that performance trumps all, or are just lazy.

    Pretty sure that was directed at the other person questioning you, not you.

    "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