Tag
SQL Server
04
Feb
Data Warehousing Tip #7 – How I build a time dimension
4th February 2019[Chris Jenkins](/content/author/chrisbidesign-uk/ "Posts by Chris Jenkins"/index.html)Data Warehousing, SQL Server
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...
28
Jan
Data Warehousing Tip #6 – Use a consistent unknown member key
28th January 2019[Chris Jenkins](/content/author/chrisbidesign-uk/ "Posts by Chris Jenkins"/index.html)Data Warehousing
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...
20
Oct
Reducing the size of the distribution database & improving transactional replication performance: Part 3
20th October 2014[Chris Jenkins](/content/author/chrisbidesign-uk/ "Posts by Chris Jenkins"/index.html)Replication Performance Tuning
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.
26
Nov
Reducing the size of the distribution database & improving transactional replication performance: Part 2
26th November 2012[Chris Jenkins](/content/author/chrisbidesign-uk/ "Posts by Chris Jenkins"/index.html)Replication Performance Tuning
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...
08
Nov
Reducing the size of the distribution database & improving transactional replication performance: Part 1
8th November 2012[Chris Jenkins](/content/author/chrisbidesign-uk/ "Posts by Chris Jenkins"/index.html)Replication Performance Tuning
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...