Tag Archives: Clustered Columnstore Index

Clustered Columnstore Index in SQL Server 2014

The clustered columnstore index which shipped with SQL Server 2014 is busy revolutionizing the Data Warehousing landscape in SQL Server. When creating a Fact Table in a data warehouse you will almost without question put a Clustered Columnstore (CCI) on … Continue reading

Posted in SQL Server 2014 | Tagged , , , | Leave a comment

Partition Switching for Big Data Loads – Partition Switch In

This is the third in a series of blogs about partition switching for SQL Server 2014. This blog will focus on the actual Alter Table … Switch statement spoken about in the first blog. A number of steps has to … Continue reading

Posted in SQL Server 2008, SQL Server 2014 | Tagged , , , , ,

Partition Switching for Big Data Loads, Partition Fact Table

This is the second edition in a series of posts describing how to implement partition switching to load a very large Fact table. The first blog post gave some insight into what partition switching is and how it works. This … Continue reading

Posted in SQL Server 2014 | Tagged , , ,