Fewer data integrity problems mean higher quality databases and more proficient end users. Every DBA should take advantage of the mechanisms provided by the DBMS to ensure data integrity. ... SQL ...

Check constraints are supported in all of the major DBMS products, including DB2, Oracle, and SQL Server. But they are too-often ignored and not implemented in production databases. Properly defined, ...

Good software habits apply to databases too. Trust in these little design tips to build a useful, rot-resistant database ...

Check Database Integrity – Runs DBCC CHECKDB to verify database integrity; Execute T-SQL Statement – Run provided T-SQL against a SQL Server.