SQL Server: Why We Should Prefer Database to Implement Data Integrity

Developers like to implement domain and referential constraints to implement data integrity on application side and forget that implementing such constraints on database their can help OPTIMIZER to select optimum query plan.