GilaMonster (10/18/2013)
3)Show me a database with integrity enforced by the application, I'll show you bad data in it.
+1 You have no idea how many arguments I had with various vendors with some latest and greatest application that used the database as simply a container with no referential integrity built into it. Along with that I'd hear things like "we've built a smart application where data integrity has been enforced in the front end and really doesn't need to be on the database"..... I would simply get up and show them the door...
Some people don't get it. I certainly will not stand for bad design.... not in my shop!
Kurt
Kurt W. Zimmerman
SR DBA
Lefrak Organization
New York, NY
http://www.linkedin.com/in/kurtwzimmerman