Author Archives: drickusa

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

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 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 2016 CTP 2

The first Public SQL Server 2016 Preview which is called SQL Server 2016 CTP2  is now available for download. Follow the link to the download site and get your copy. The following TechNet webpage will give you a brief overview … Continue reading

Posted in SQL Server 2014 | Tagged | 1 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

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