Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> SQL Server Katmai >> SQL Server Katmai Database Engine

Will we be able to partially compress table?

I explain, typical DW scenario. The last n days are used a lot, the rest NEVER or RARELY... will I be able to compress that big and fat calldetail table for days older then 31 for example? seamlessly?

It would be so great!!

[231 byte] By [MAthieuDumais-Savard] at [2008-1-19]
«« Can anyone help me plzzzz?
»» binding and converters when the value does not change
# 1
This can be done in SQL Server 2005 as well. What you need to do is creating at partitioned table, where the "old" data resides in a read-only filegroup. Both SQL Server 2005 and 2008 supports NTFS compression of read only databases and filegroups.
OleKristianBangaas at 2007-10-3 > top of Msdn Tech,SQL Server Katmai,SQL Server Katmai Database Engine...
# 2
Yes, you will be able to do this if you use different partitions.

We will provide more details when compression is available in a CTP.

Thanks,

MarcelvanderHolst-MSFT at 2007-10-3 > top of Msdn Tech,SQL Server Katmai,SQL Server Katmai Database Engine...
SQL Server Katmai
SQL Server Katmai Database Engine

SQL Server Katmai Hot Topic

SQL Server Katmai New Topic

SQL Server Katmai

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified