Query Temporal DataCommented on: 6 years ago
(October 17, 2008)
Terrific! I was able to put this to use immediately. However, I needed to track temporal data by object (location and status in my case) so I added a piece identifier to solution 3 like so:
Data Warehousing: Rapidly Changing Monster DimensionsCommented on: 6 years ago
(March 13, 2008)
Although I have played with the monster dimension you discuss, I have settled on a couple of different approaches instead. If the things that describe the dimension item are finite, like a billing...
Digital Magazine Archives
Browse back issues of SQL Server Pro, from January 2007 through the last issue published in April 2014. Find the back issues here.