Blog - Title

January, 2008

  • SQL Server Storage Engine

    Compression Strategies

    • 4 Comments
    In the previous blogs, I had described the data compression in SQL Server 2008 and its implications on CPU and IO. One of the question that keeps coming up is ‘Should I compress my database? Or Why does the SQL Server not provide an option to compress...
  • SQL Server Storage Engine

    Details on page compression (page-dictionary)

    • 1 Comments
    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, this dictionary is specific to a page and the page can be data...
  • SQL Server Storage Engine

    Details on PAGE compression (column-prefix)

    • 2 Comments
    In the previous blog, I had mentioned that the PAGE compression is used to “minimize the data redundancy in columns in one or more rows on a given page”. You may wonder what exactly SQL Server does under the PAGE compression cover? With PAGE compression...
Page 1 of 1 (3 items)