It’s amusing because a institution and I were having a discussion in the kitchen the other day about the whole ‘no SQL’ movement, and my top to him was that many of the advantages pertained to having a columnar storage space model, and (especially in the light of Vertipaq) I didn’t reflect it would be long before this kind of storage space mode migrated to mainstream RDBMs’s like SQL Server.

And then this, in Denali (Sql Server v-next):

“The columnstore index in SQL Server employs Microsoft’s patented Vertipaq™ technology, which it shares with SQL Server Breakdown Services and PowerPivot. SQL Server columnstore indexes don’t have to fit in main reminiscence, but they can effectively use as much reminiscence as is available on the server. Parts of columns are went in and out of reminiscence on demand.”

MVP’s have been able to download CTP1 for a fortnight apparently, which means Mitch has been holding out on me. Damn his poker face.

Check it out:Cup(Of T)