Category Archives: SQL Server 2012

Rebuild a Specific Partition

The following code snippet will enable you to rebuild a specific partition on an index in SQL Server. This is very useful when the table in question is very large and you only want to rebuild the specific partition that … Continue reading

Posted in SQL Server 2008, SQL Server 2012, SQL Server 2014 | Tagged , , | 1 Comment

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

SQL Server SSMS Color Coded Status Bar

Have you ever experienced the nauseating feeling when running an update, delete or truncate statement thinking you are working on the development server while the connection is actually pointing to production database server in SQL Server Management Studio (SSMS). You … Continue reading

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

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

Stop SSIS Package execution in SSIS.Catalog

This article is about explaining how to cancel or stop a job that was executed directly from the SSIS.Catalog. I executed a SSIS Package directly from the SSIS.Catalog where I subsequently had to cancel the process. My research lead to … Continue reading

Posted in SQL Server 2012, SQL Server 2014 | Tagged , , , , , , | 1 Comment

SQL Server data warehouse performance settings

This is the checklist you need to ensure your SQL Server environment is optimally setup for Data Warehouse loads. I have compiled it based on experience and the FastTrack data warehouse reference architecture. Confirm that Windows Server 2012 Application Server … Continue reading

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

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