Maintaining history in a production (online transaction processing—OLTP) database can be tricky. You want to be able to retain readily available historical facts in the database while sustaining performance. If you don't correctly control the architecture of this historical data, not only can you significantly increase the number of records in your production tables but you can also cause queries that...