In the previous blogs, I had described the data compression in SQL Server 2008 and its implications... and estimated compression savings using sp_estimate_data_compression_savings stored procedure. Let us look... these objects or not. · The compression savings are schema/data dependent and in fact for some objects

Thanks to all who have contacted me for their interest in the data compression feature. Unfortunately, data compression feature is NOT available in the just released CTP-5 which is now available.... Data compression will be released with CTP-6. Also, Data Compression is an Enterprise Only feature

-compression-on-a-heap.aspx, I described how to enable compression on a HEAP. You can enable either ROW or PAGE compression on the heap. Let me now describe the implications of DML operations on a heap. ROW compression: No issues. The updated/inserted data stays ROW compressed though out its life time

As I described in my previous blog, the data compression feature has been very successful. We do... our data compression offering in future releases.Hereissome ofthefeedackand the respectiverationale. Please feel free to contact me for your suggestions on data compression. (1) Provide Unicode

Now that we have Unicode compression available in SQL Server 2008R2 as described in, let me take a simple example using AdventureWorksDW databaseto show you the additional compression that can... characters of NVARCHAR types. With Unicode compression, we will expect that the average length

BLOG I will discuss DML operations on the HEAP and compression Thanks Sunil...I often get a question how to do enable compression on a table that is a heap (i.e. it does not have a clustered index). Clearly, one could create the clustered index with compression option set

In myprevious blog, I had mentioned that unicode compression will be available as part of next SQL.../sqlserver/2008/en/us/r2.aspx to play with it. This is anew exciting addition to thedata compression...,increase the storage requirements significantly. Solution: SQL Server implements unicode compression

Like I had indicated in my previous blog, it is recommended that you estimate compression savings on the object of interest before actually enabling compression as enabling compression is an expensive operation. To show how to estimate data compression, I have created a very simplistic

/archive/2007/09/30/data-compression-why-do-we-need-it.aspx) that data compression is a good thing, you may wonder how SQL Server compresses the data, what does this compression mean to my data and to my workload... and find many fine techniques to compress the data but note, not all compression techniques are applicable

In the previous blog, I described column-prefix compression that is done as part of PAGE compression. The other component of PAGE compression is the page-dictionary. As the name indicates... of an index are ROW compressed even if you choose to compress the index with PAGE compression option