Tag Archives: Partition Switch

Partition Switching for Big Data Loads – Partition Switch Out

This is the last in a four part series of blog post explaining Partition Switching using SQL Server 2014. Before switching data into a specific partition we must first ensure the relevant partition is empty, otherwise the Partition Switch In … Continue reading

Posted in SQL Server 2008, SQL Server 2012, 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 , , ,

Partition Switching for Large Data Loads

This is the first in a four-part series of blog posts explaining my journey using SQL Server’s partition switching functionality to load a very large Fact tables. Partition switching is a Microsoft best practice data loading technique as described in … Continue reading

Posted in SQL Server 2005, SQL Server 2008, SQL Server 2012, SQL Server 2014 | Tagged , , , , , | 2 Comments