Post reply

Data Compression - Clustered Index

  • February 17, 2011 at 8:54 am

    #1288293

    I guess I am wondering how populated the columns are. I see that you allow NULLs so wondering if they are mostly NULL at this point or is there actually data in those columns in most rows. If they are mostly NULL then the lack of compression evidenced would be expected.

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • February 17, 2011 at 9:12 am

    #1288309

    Two of the columns are almost never NULL, the other two are more 70% null-30% data.

  • February 18, 2011 at 6:49 am

    #1288807

    If it's XML data, you should store it as typed XML, with defined XML schemas. That'll help with storage size and compressibility.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply