Showing how the DELETE CASCADE clause works and why you might not want to be tempted by it
Data Structure
A heap is a table that has no clustered index – it may have non-clustered indexes but without a clustered index it is a heap. When a row is updated within the heap, if the new data size means a row cannot be stored in the original location, SQL Server moves the row to another …
Notes on SQL 