constraints should be the first option for enforcing data integr

if it's not applicable, consider trigger.

I use trigger for auditing. trigger is often regarded by some people as source of pain && bottle neck of performance.

I'm ok with it.

For data retrieving, store procs is the first candidate for sure.

my 0.002 cents

thx 布衣~~