Monthly Archives: May 2014

Practical Clustered Columnstore Index on Parallel Data Warehouse (part 2)

PDW 2012 | APS 2012 In part 1 of this topic, I showed how basic insert operations in a CCI table are handled internally. As we saw, inserting of large batches causes the CCI to compress the data immediately (apart … Continue reading

Posted in Allgemein | Leave a comment

Practical Clustered Columnstore Index on Parallel Data Warehouse (part 1)

PDW 2012 Together with the parallel query engine, the clustered column store index (CCI) gives the Parallel Data Warehouse (PDW) an outstanding query performance. As with SQL Server 2014, data is natively stored in compressed format, giving these advantages: less … Continue reading

Posted in Allgemein | Leave a comment