SQL Server 2014 will offer Clustered Columnstore Indexes. These will offer the performance and compression benefits of column-oriented storage without the need to restrict the underlying table to ...

A clustered CS Index can have one or more nonclustered rowstore indexes. It will provide support for primary keys and foreign keys by using a B-Tree index to enforce these constraints on a ...