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?
_________________________________________________________________________
SSC Guide to Posting and Best Practices