• 100% agree with ironpants. You should start with RI enforced always, and only ever consider removing it in special cases (usually for performance issues that can't be solved any other way) and when doing so make the business fully aware of the risks. How many of us are absolutely certain that all processes that touch the DB are perfectly written and respect our non-RI enforced relationships?

    Regards,

    Jacob