Category Archives: SQL Server 2008

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

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

Recommended Maxdop for SQL Server

There are some server level settings in SQL Server that you want to, and must, change. Each installation and client environment is different. Hence you want to get the best performance from you SQL that you can based on your … Continue reading

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

Why is my data warehouse always out of disk space?

This question most customers ask business intelligence (BI) consultants who implemented data warehouse (DWH) or BI solutions. Not stating the obvious, DWH’s do grow over time, what we need to pay attention to is the database log space. The log … Continue reading

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