Slowly Changing Facts
This article describes a design pattern for storing “effective dated" changes to fact tables.
2013-10-18 (first published: 2010-12-22)
20,034 reads
This article describes a design pattern for storing “effective dated" changes to fact tables.
2013-10-18 (first published: 2010-12-22)
20,034 reads
Describes a design pattern for using CDC to power fast and efficient incremental data loads.
2013-06-07 (first published: 2011-01-17)
26,333 reads
This article describes a technique of using FULL JOINs to compare two datasets within a numerical tolerance.
2013-04-23 (first published: 2010-09-27)
30,403 reads
You can find the slides for my session at Future Data Driven summit at...
By Steve Jones
I saw someone limit the databases they see in SSMS, which isn’t something I...
Since witnessing a rather nasty cyber attack around a year ago, I’ve been thinking...
Hi all, I have an SQL database table with events, and within it a...
Hi All, I have been trying to download a csv file which is produced...
Hi We have an stored procedure which runs frequently and it contain logic in...