December 12, 2003 at 8:13 am
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
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
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
This might also be of interest to you
http://support.microsoft.com/default.aspx?scid=kb;en-us;231347
Frank
--
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
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