By using cascading referential integrity constraints, you can define the actions that SQL Server 2005 takes when a user tries to delete or update a key to which existing foreign keys point.

In part 2 of a series, On VB columnist Joe Kunk provides a Visual Basic program to generate a SQL script that clears all the data from a SQL Server database ... dropping and re-creating foreign key ...

If you have too many indexes, the whole database can slow down under heavy write and update ... foreign keys and relations between tables. I’ll explain this by using examples in DDL, using SQL ...