April 3, 2015 at 2:01 am
Hi Experts,
Can you please share your experiences on what basis should we decide to go with Page or ROW Compression?
April 3, 2015 at 3:20 am
Ravid_ds (4/3/2015)
Hi Experts,Can you please share your experiences on what basis should we decide to go with Page or ROW Compression?
Quick answer, it depends.
😎
Start by reading through these articles
Data Compression: Strategy, Capacity Planning and Best Practices
Practical Data Compression in SQL Server
A Quick Introduction to Data Compression in SQL Server 2008[/url]
April 3, 2015 at 7:20 am
Thank you 🙂
April 4, 2015 at 6:23 am
my experience is, I tried to do 'page compression' on a table to gain some 'free space' on the databases level. But when I did it, i got more 'free space' (unallocated space) but .mdf file size also grew.
I was expecting .mdf size (G:) size remains same and free space on the database would grow, but didn't happen.
so what's point doing this?
April 4, 2015 at 6:36 am
Tac11 (4/4/2015)
my experience is, I tried to do 'page compression' on a table to gain some 'free space' on the databases level. But when I did it, i got more 'free space' (unallocated space) but .mdf file size also grew.I was expecting .mdf size (G:) size remains same and free space on the database would grow, but didn't happen.
so what's point doing this?
The compression rate depends on the data types and the actual data etc., one must look into this before applying the compression, in certain cases it will only make things worse. Strongly recommend reading through the articles (links in previous post) for better understanding of the compression technology implementation is SQL Server.
😎
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply