Blog

Data Warehousing Tip #1 - BI Design Hampshire

0 Data Warehousing

•10th December 2018

Data Warehousing Tip #1 – Store fact data at the leaf level

My first data warehousing tip is to store fact data at the leaf level. If you aggregate your...

2 Replication Performance Tuning

•20th October 2014

Reducing the size of the distribution database & improving transactional replication performance: Part 3

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

4 Replication Performance Tuning

•26th November 2012

Reducing the size of the distribution database & improving transactional replication performance: Part 2

The impact of having data sitting in the distribution database that doesn’t need to be there can be...

0 Replication Performance Tuning

•8th November 2012

Reducing the size of the distribution database & improving transactional replication performance: Part 1

In this series of blog posts I will looking at issues regarding the size and performance of the distribution...

1 2