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 fact data...
2018-12-10
314 reads
Chris Jenkins' Blog
Reducing the size of the distribution database & improving transactional replication performance: Part 3
Part 1 of this series of articles looked at the intricacies of SQL Server transactional replication, and made the observation that the...
2014-10-27 (first published: 2014-10-20)
6,811 reads
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 significant. The...
2012-11-26
3,964 reads
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 database as...
2012-11-08
18,667 reads
Blogs
Enterprise AI Operating Rhythm – Top 5 practices for 2026
2025 exposed a growing gap between AI ambition and operational reality. As budgets tightened...
Stop Being Surprised by Your Azure Bill: Use Budgets
By John
When organizations migrate workloads to Azure, the focus is usually on architecture, performance, and...
Resetting on the AI hype train
By Brian Kelley
There's a great article from MIT Technology Review about resetting on the hype of...
Forums
Celebrating Tomorrow
Comments posted to this topic are about the item Celebrating Tomorrow
SQL Art: I Made a Christmas Card In SSMS
Comments posted to this topic are about the item SQL Art: I Made a...
lookup error
I am using ssrs in visual studio 2022, I work on a report, there...
Question of the Day
Celebrating Tomorrow
Which of these is more appropriate for tomorrow?
See possible answers