Category Archives: Columnstore indexes

Columnstore indexes and memory

Columnstore indexes are built and processed completely in memory.  You will receive an out-of-memory error if you do not have enough memory to build the columnstore index.  Column store processing is optimized for in-memory processing, however, they do not reside in memory … Continue reading

Posted in Columnstore indexes, SQLServerPedia Syndication | 1 Comment

SQL Server 2012 (“Denali”): Project Apollo/Columnstore Indexes

Project Apollo is a new feature in CTP3 of SQL Server 2012 (code name of “Denali”) that enables a new columnstore index that offers 10-100x performance improvements for a star join or similar query.  Apollo brings together the in-memory columnstore … Continue reading

Posted in Columnstore indexes, SQL Server, SQL Server 2012, SQLServerPedia Syndication | 8 Comments