Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Page Compression Expand / Collapse
Author
Message
Posted Monday, June 13, 2011 10:59 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, July 25, 2014 9:09 AM
Points: 395, Visits: 168

Nice question!

See Data Compression: Strategy, Capacity Planning and Best Practices in ( http://msdn.microsoft.com/en-us/library/dd894051%28v=sql.100%29.aspx )
Post #1124446
Posted Monday, June 13, 2011 12:36 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, November 10, 2014 12:05 PM
Points: 3,969, Visits: 3,648

Good question and great topic, thanks.
Post #1124524
Posted Monday, June 13, 2011 7:26 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 5:24 PM
Points: 5,370, Visits: 9,009
Steve, this is a really good question. Thanks!

Wayne
Microsoft Certified Master: SQL Server 2008
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links: For better assistance in answering your questions, How to ask a question, Performance Problems, Common date/time routines,
CROSS-TABS and PIVOT tables Part 1 & Part 2, Using APPLY Part 1 & Part 2, Splitting Delimited Strings
Post #1124705
Posted Monday, June 13, 2011 8:53 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 2:03 PM
Points: 2,278, Visits: 3,806
Tom.Thomson (6/13/2011)
Good question.

But one major niggle and one minor niggle:

Major niggle: if page compression is enabled on a table already containing data, each page is rebuilt and evaluated for page compression; page compression can occur here (unless I've got it wrong) and may make the data fit into fewer pages than if only row compression occurred. So the answer always applies to pages which are empty/unallocated when compression is enabled, but not always to pages which already contain data when compression is enabled.

Minor niggle: page compression won't occur even when a new row doesn't fit if the engine determines that page compression would not free up a significant amount of space.

edit: SCTEs


Thanks Tom for adding these points, very useful really.


Mohammed Moinudheen
Post #1124718
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse