Data integrity, who is responsible?
The constraints available in SQL server are mentioned to maintain the integrity of data in the database.
There is some tension between dba's and the developers who is responsible for the integrity of the data in the database. Developers can handle a lot of things in code including checking is the value entered is the right value for the column in the database. DBA's on the other hand can apply some constraints wich does some data checking on database level. Both are causing some performance loss. So what to do?
Well, do anything but never delete the constraint, its youre saving-line for data-integrity.
- Foreign key