Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase «««1234

Consistent Data Presentation Expand / Collapse
Posted Friday, April 22, 2011 2:20 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, October 25, 2013 7:43 AM
Points: 1,384, Visits: 644
choose 2 eliminates 5

Post #1097630
Posted Wednesday, May 25, 2011 12:57 AM


Group: General Forum Members
Last Login: Monday, November 28, 2016 9:58 AM
Points: 2,674, Visits: 601
Easy question, and many users have answered correctly, but why do I find a lot of worst practices everywhere?

It is far too common for many developers to write the logic in many places and store the data in more than one place without any of few constraints. They seem to think that they can handle the consistency much better and faster in the business logic than SQL server can with foreign key and check constraints. It may work fine in smaller systems with few developers, but when someone quit and a new developer comes in everything goes wrong and the data becames inconsistent.

On the other hand this "bad behavior" gives us SQL server consultants many assignments. :)

/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
Post #1114537
« Prev Topic | Next Topic »

Add to briefcase «««1234

Permissions Expand / Collapse