HomeSQL Server 2014SQL Server 2014: Columnstore Index improvements

Comments

SQL Server 2014: Columnstore Index improvements — 2 Comments

  1. Nice post I’m glad some of the PDW work/research is going into the new SQL Server. That thing is a beast!

    So just a quick clarifying question. The SQL Server data pages will now how column information in it instead of row using the new Clustered Column Store Index right?
    So let’s say a column is 64kb in size, that one column will take up an entire extent, while another column in the same table could be on other pages in a different extent? I feel like I have to turn my head sideways now when looking at how data is stored.

  2. How does this now writable index affect the speed of ETL bulk inserts? Is the effect similar to an already page compressed table as described in the white paper “The Data Loading Performance Guide”?

Leave a Reply

Your email address will not be published. Required fields are marked *

HTML tags allowed in your comment: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>