Post reply

Table size... need to reduce but how?

  • September 10, 2011 at 9:23 am

    #256976

    I have a scenario where table size is larger than Databse size, for example if the DB size is 200GB , then table size is 210 GB, Can you help me to suggest various ways to reduce the size of that table?

  • September 10, 2011 at 1:41 pm

    #1379625

    How did you measure those numbers? It's unlikely a single table can be larger than the whole DB (unless there are different filegroups and not all have been taken into account when calculating the db size...).


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • September 10, 2011 at 5:07 pm

    #1379643

    meghna.bhargav (9/10/2011)

    Can you help me to suggest various ways to reduce the size of that table?

    You can purge data from the table that you no longer need to reduce the table size. Or you can archive old data outside database(bcp?) or to an archive table and then purge. Or you can backup the database, keep the backup at a safe location and then purge.

    Ways to do it - Delete Statement


    Pradeep Singh

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply