Most databases I meet as a consultant have no up-to-date documentation. Here is the hard way and the soft way to check SQL SERVER – View Dependencies yourself.
Circular Foreign Keys: Inserting Rows That Point at Each Other
Two tables point at each other, and every insert fails. Here is the nullable column that gives you a way in.
SQL SERVER – Finding Tables with Primary or Foreign Keys
How do you find which tables have a primary key or foreign key? Here are simple queries for finding tables with primary or foreign keys in a database.
Interview Question of the Week #001 – Script to List Foreign Key Relationships and Constraint Name
List foreign key relationships with schema names, matched columns, referential actions, and trust flags using SQL Server catalogs.
SQL SERVER – How to Disable and Enable All Constraint for Table and Database
Readers often ask how to disable and enable all constraint for table and database. Here are simple ALTER TABLE scripts for both, plus one for a single constraint.
Block Predicates: Stopping Writes Into Another Tenant’s Rows
A filter predicate hides rows but does not stop a bad write. Here is how block predicates close that gap, with a demo you can run.
Foreign Keys Without Indexes: Finding and Fixing Slow Deletes
Find foreign keys without indexes, inspect parent-delete plans, and choose leading child-table keys that support relationship checks.