Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2008
    Posts
    6

    Database statistics

    Hi,
    I am not sure whether this post should come in this category.
    We have approximately 25GB size records spanning 5 tables.Monthly database size increases by 200MB.These records will be useful only for reporting purpose in future.Hence records need to be deleted.Before deletion we are thinking of creating statistics of all the records so that it will be shown in reports.Database is MS SQL 2005.
    What needs to be shown in report depends on statistics module.
    Does SQL 2005 provides some sort of statistics module or compression utility etc? nre database with different table structure to be created?
    Regards
    PD

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Quote Originally Posted by pdiwadkar
    These records will be useful only for reporting purpose in future.Hence records need to be deleted.
    "These records will be useful, so we are going to delete them"?
    Huh?
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    I think he means "archived and THEN deleted". 200MB a month added? It's a very small chunk of data. Have you determined how much data is being modified? Your task at hand should be to aggregate into your reporting database, and then delete from prod. No statistical module in SQL, just a whole slew of ways how to do it, it's up to you
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    So, by "creating statistics" he is probably not talking about index statistics. He is talking about aggregate statistics on the data.
    Seems like this could be created from the archived data as well.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •