I have seen them be extremely useful where sometimes a race condition would occur but the data integrity was saved because of the Db constraints