data-konzept

'One of my most favorite technologies is Columnstore. Thankfully, the guys at Microsoft seem to agree with me, because they continue developing this technology and make it faster and faster.

In a nutshell, as oppose to what we’re used to today, a Columnstore index keeps our data at the column-level instead of the row-level. Because the values of the same column have the same data type and tend to repeat themselves, there are many options for optimizations and compressing the data.'...

http://www.sqlservercentral.com/blogs/db-newsfeed/2016/04/27/columnstore-index-enhancements-in-sql-server-2016/