Tag Archives: ETL

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

Useful Tips in using BIML in BidsHelper

This is a follow up post on the first post my colleague and owner (Louw Fouche) of sabigdata, wrote around BIML and generating SSIS packages. This article will focus on some of the insights we gained using BIML for Source to … Continue reading

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

Top 10 SSIS Performance Best Practices

The SQL CAT team has loads of experience in loading large volumes of data using SQL Server Integration Services. Thanks to the team for putting this wonderful post together. Here are highlights plus some of my own tips: Do all … Continue reading

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

SQL 2008 ETL Performance Rocks

Here is a very interesting site from the SQL Team on their World Record ETL Performance loading 1.18 TB in under 30 minutes.

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