title: When/Why to use Cascading in SQL Server?
body: <p>When setting up foreign keys in SQL Server, under what circumstances should you have it cascade on delete or update, and what is the reasoning behind it?</p>
  
  <p>This probably applies to other databases as well.</p>
  
  <p>I'm looking most of all for concrete examples of each scenario, preferably from someone who has used them successfully.</p>