Chapter 11. Keeping History Data
After completing this chapter, you will be able to:
Create and use database snapshots
Design effective history tables for summarizing historical data
Create and use indexed views to summarize your historical data
Build audit columns and tables to track changes in your data
Use audit tables to recover lost data
The previous chapter discussed using transactions to ensure the integrity of your data. This chapter delves into ensuring data integrity by tracking changes and storing historical versions of the data that can be restored if needed without restoring the entire database.
Historical data can take many different forms, from auditing to data warehousing for analytics. This chapter concentrates on methods for auditing ...
Get Microsoft® SQL Server™ 2005: Applied Techniques Step by Step now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.