Tag Archives: SQL Server

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 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