I’m Carla Abanes, working as a full time Senior SQL Database Administrator here in Singapore for an established financial trading firm.
Columnstore index is the new type of index introduced in SQL Server 2012. It is a column based non-clustered index geared toward increasing query performance involving large result sets, ideally in fact tables for OLAP query. This type of index is based on Vertipaq engine acquisition. Columnstore indexes in the SQL Server Database Engine can […]