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
315 reads
My first data warehousing tip is to store fact data at the leaf level. If you aggregate your fact data...
2018-12-10
315 reads
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
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,971 reads
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,730 reads
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
By Steve Jones
One of the features we advocates have been advocating for is a better way...
Comments posted to this topic are about the item Level 28: DAX Text Functions:...
Comments posted to this topic are about the item Creating JSON I
Comments posted to this topic are about the item Expensive CPUs
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( 'City':'Denver') GOSee possible answers