In this article I’m going to show you how I build my time dimensions.  There are lots of different ways to create time dimensions, and there are lots of different requirements, from the attributes in the dimension to the granularity of the data.  You can use these scripts to build an entire time dimension, and...Read More

In this article I’ll be discussing the benefits of using a consistent unknown member key across your data warehouse.  And I’ll show you a couple of ways of going about implementing a consistent approach. Each of your dimensions should have an unknown member key.  The aim of which is to ensure all source data flows...Read More

The final (and much delayed) part of this series focuses on the choice between replicating stored procedure calls and replicating the data modified by stored procedure calls.Read More

The impact of having data sitting in the distribution database that doesn’t need to be there can be significant.  The aim of this series of articles is show you how to keep the distribution database as small (and efficient) as possible, and to keep the impact of the clean-up job to a minimum.  Each of...Read More

In this series of blog posts I will looking at issues regarding the size and performance of the distribution database as part of a transactional replication environment. Symptoms: Your distribution database is growing quite large The distribution cleanup job is taking a long time to run, yet not clearing as much data as you would expect...Read More