title: Should I use the CASCADE DELETE rule?
body: <blockquote>
    <p><strong>Duplicate of: <a href="https://stackoverflow.com/q/59297/1288">When/Why to use Cascading in SQL Server?</a></strong></p>
  </blockquote>
  
  <p>I've always been too scared to use DELETE CASCADE, but as I get more confident (lazy :D), I'm thinking how bad can it be, is it best practise to use it or should I avoid it and clean up my foreign keys etc the old fashioned way (with stored procedures)?</p>