Category Archives: SQL Server 2005

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

SQL Joins in SSIS Lookup Component

I’m amazed at how many ETL developers do not know how to perform simple SQL Joins by using SQL Server Integration Services (SSIS) 2005. SSIS has several Dataflow components that can could be used accomplish this SQL task. Today I … Continue reading

Posted in SQL Server 2005 | Tagged , | 2 Comments