YOUR CHANNEL IS LOADING

LATEST EPISODES MORE EPISODES

  • 1

    The Control Poll

  • 2

    Honeywords in SQL Server

  • 3

    The Challenger

  • 4

    The Platform Problem

  • 5

    Better Coding, More Savings

The Voice of the DBA Read-only Data

MEVIOtoday

Jan 05, 2012 Read-only Data

We keep gathering, storing, and managing more and more data. Many of our systems could use an archiving plan to migrate older data to another database or system where it can be accessed, but it won't impact the performance of queries against our current data. If you don't have any type of archive plan, you might consider building one for any future tables you design.

Once you migrate data to a new set of tables, typically you would consider that older data to be read only, and potentially mark it as such in it's own storage location, perhaps even adding more indexes than you have on the current data. And if the data is static, then it doesn't change from week to week, and you can reduce the amount of backups that you create from this data.
Read the rest of "Read-only Data" at SQLServerCentral.