Jason-299789 (7/30/2013)

---

Andreas Wolter-332291 (7/16/2013)

---

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

Quick question on this, with the 2012 Columns stores they where memory intensive in during thier creation and also took longer than a Clustered index to apply.

Is this still the case?