This video discusses the types of constraints you can use in SQL Server and how they can be use to maintain data integrity. SQL Server constraints define rules regarding the values allowed in columns and are the standard mechanism for enforcing integrity. Using constraints is preferred to using DML Triggers, rules and defaults. The query optimizer also uses constraint definitions to build high-performance query execution plans.
[youtube imRj2wwTgAY]
Video Producer: http://www.joes2pros.com/