Post reply

Compress tables or filegroups

  • December 12, 2003 at 8:13 am

    #177374

    Does SQL Server 2000 has the capabilities of compressing tables or filegroups?

    I have a partitioned view which contains the last 14 days of data (in 14 tables). The older tables are detached from the partitioned view and I need to archive them (for read only purposes). Each table contains between 20 and 80 million rows, so compression is one of the features that will allow me not to run out of space quicker.

    Thanks

  • December 12, 2003 at 8:38 am

    #485964

    IMO this is not supported for sqlserver.

    (unlike DB2)

    What you could do is alter the clusterd index of those partitioned-view-parts to 100% fill and rebuild it. Keep in mind to put logging to simple or bulk-logged for this operation. Maybe you could also put the partitioned-view-parts each in singel-table-databases, so you can put the db in read-only mode to avoid locking overhead.

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • December 12, 2003 at 11:50 am

    #486004

    Thanks alzdba

    Yes, I will be moving them to different databases and marking them as read only, so they are backed up once too.

    I just started adminitrating sql server 2000, and there are features that it lacks (composite partitioning is one). Luckily, most DDLs and DMLs are portagble from oracle, or require small changes.

    Oscar

  • December 12, 2003 at 12:37 pm

    #486017

    This might also be of interest to you

    http://support.microsoft.com/default.aspx?scid=kb;en-us;231347

    Frank

    http://www.insidesql.de

    http://www.familienzirkus.de

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • December 12, 2003 at 2:12 pm

    #486034

    Thanks Frank Kalis.

    I really didnt think on that either. The article is clear with "not supported" clause.

Viewing 5 posts - 1 through 4 (of 4 total)

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