Tag Archives: Data loading

Best Practices for Building a Large Scale Data Warehouse

You walk into the office today and your client, or your boss, asks you to build a warehouse. All seems fine and dandy, right. You are the developer and this should be easy. “O, and by the way, our 5 OLTP systems … Continue reading

Posted in 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 Big Data Loads, Partition Fact Table

This is the second edition in a series of posts describing how to implement partition switching to load a very large Fact table. The first blog post gave some insight into what partition switching is and how it works. This … Continue reading

Posted in 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

SQL Server data types in .Net Framework

The good folks at Microsoft did a wonderful job at providing us with a SQL Server data type mapping for the .Net Framework. This is especially useful when you are working with SSIS or have some BimlScript. I used it … Continue reading

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

Dynamic source data type length calculation

On every BI project you will be required to pull in data from a source system into a staging database. In order to do this you will need to determine what the appropriate field lengths and data types. For example … Continue reading

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

Impact of page compression on data warehouse loads

As a data warehouse professional you are faced with some trade-offs. One of them is speed versus space. The article below shares some interesting facts about applying compression to tables. It indicates the affect page compression has on bulk load … Continue reading

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