• Even though SQL 2014 is by far not complete in CTP1 and more is to come, you should be ready for a new way of developing Datawarehouses - if In-Memory-OLTP is not enough "developer-stuff" for you.

    Why is that?

    Because it can be foreseen, that from that release on, ColumnStore will be the new standard storage-format for Facts as well as Dimensions - which is a big shift from anything before.

    You can read some more on the reasons behind here: www.insidesql.org/blogs/andreaswolter/2013/06/sql-server-2014-columnstore-indexes-batch-mode-improvements

    cheers,

    Andreas

    Andreas

    ---------------------------------------------------
    MVP SQL Server
    Microsoft Certified Master SQL Server 2008
    Microsoft Certified Solutions Master Data Platform, SQL Server 2012
    www.insidesql.org/blogs/andreaswolter
    www.andreas-wolter.com