Abrar Ahmad_ (7/5/2010)
My design strategy for a medium level transactional DB (10 K - 500 K data records/Day) would be to not implement foreign key constraints?
Half a million records a day is not a high-volume SQL database, not on appropriate hardware. There's no need to go to extreme measures (like dropping constraints) on a transactional volume that small.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability