Query Temporal DataCommented on: 5 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...
When DBAs and SysAdmins learn the ins-and-outs of AlwaysOn Availability Groups, they’re then able to address high availability and disaster recovery concerns from a single interface or set of tooling, thus providing better scalability of management....More