### Tag

SQL Server

04

Feb

### [Data Warehousing Tip #7 – How I build a time dimension](/content/data-warehousing-tip-7/index.html)

[4th February 2019](/content/2019/02/04/index.html)[Chris Jenkins](/content/author/chrisbidesign-uk/ "Posts by Chris Jenkins"/index.html)[Data Warehousing](/content/category/data-warehousing/index.html), [SQL Server](/content/category/sql-server/index.html)

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](/content/data-warehousing-tip-7/index.html)

28

Jan

### [Data Warehousing Tip #6 – Use a consistent unknown member key](/content/data-warehousing-tip-6/index.html)

[28th January 2019](/content/2019/01/28/index.html)[Chris Jenkins](/content/author/chrisbidesign-uk/ "Posts by Chris Jenkins"/index.html)[Data Warehousing](/content/category/data-warehousing/index.html)

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](/content/data-warehousing-tip-6/index.html)

20

Oct

### [Reducing the size of the distribution database & improving transactional replication performance: Part 3](/content/reducing-the-size-of-the-distribution-database-improving-transactional-replication-performance-part-3/index.html)

[20th October 2014](/content/2014/10/20/index.html)[Chris Jenkins](/content/author/chrisbidesign-uk/ "Posts by Chris Jenkins"/index.html)[Replication Performance Tuning](/content/category/replication-performance-tuning/index.html)

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](/content/reducing-the-size-of-the-distribution-database-improving-transactional-replication-performance-part-3/index.html)

26

Nov

### [Reducing the size of the distribution database & improving transactional replication performance: Part 2](/content/reducing-the-size-of-the-distribution-database-improving-transactional-replication-performance-part-2/index.html)

[26th November 2012](/content/2012/11/26/index.html)[Chris Jenkins](/content/author/chrisbidesign-uk/ "Posts by Chris Jenkins"/index.html)[Replication Performance Tuning](/content/category/replication-performance-tuning/index.html)

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](/content/reducing-the-size-of-the-distribution-database-improving-transactional-replication-performance-part-2/index.html)

08

Nov

### [Reducing the size of the distribution database & improving transactional replication performance: Part 1](/content/reducing-the-size-of-the-distribution-database-improving-transactional-replication-performance-part-1/index.html)

[8th November 2012](/content/2012/11/08/index.html)[Chris Jenkins](/content/author/chrisbidesign-uk/ "Posts by Chris Jenkins"/index.html)[Replication Performance Tuning](/content/category/replication-performance-tuning/index.html)

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](/content/reducing-the-size-of-the-distribution-database-improving-transactional-replication-performance-part-1/index.html)