Viewing 15 posts - 16 through 30 (of 37 total)
A pet peeve of mine is not when companies or HR departments refer to people as resources, but when we in IT do so. I'll be in planning meetings...
May 25, 2011 at 9:15 am
I also use dim_ and fact_ prefixes/suffixes on tables as a practice, whichever my client prefers based on their naming standards.
I have seen schemas used only once in a data...
May 19, 2011 at 9:03 pm
Steve I remember Kevin Cox from MS mentioning at a user group meeting last year that Major League Baseball was a already SQL Server user. I believe he talked...
May 6, 2011 at 11:24 am
From a conceptual design point of view, an accumulating snapshot fact table would be the way to go. However there are many pitfalls.
--Accumulating snapshots are best used...
May 4, 2011 at 12:16 am
It seems to me that you have a fundamental disagreement between your requirements and your design. Based on what you are measuring it seems the fact should be an...
May 3, 2011 at 1:08 pm
An accumulating snapshot fact table would still have only one fact per order if the grain of the fact table is a single order. An accumulating snapshot would allow...
April 26, 2011 at 5:39 pm
A way to get the to the detail level of a cube is to have a dimension in that cube that has a 1-1 relationship with the fact data. ...
April 26, 2011 at 10:18 am
I agree with Ron regarding the accumulating snapshot fact table. It is the correct way to go about designing this fact table. Don't be afraid to update fact...
April 25, 2011 at 11:09 am
grc2264 (2/7/2011)
Wouldn't it be easier to hire the right person in the first place?
Excellent point. If you lie and don't get hired, shame on you. If you lie...
February 7, 2011 at 4:10 pm
Steve Jones - Editor (7/2/2010)
July 2, 2010 at 9:12 am
A financial services company I did some work for had an application that created most of its important tables on the fly. The app generated DDL when it needed...
June 11, 2010 at 10:16 am
Steve Jones - Editor (2/24/2010)
February 24, 2010 at 4:31 pm
I don't use hungarian notation in databases. I prefer clear, consistent and unabbreviated names such as CUSTOMER_LOCATION instead of tblCustLoc. If I have to distinguish between a view...
January 25, 2010 at 9:48 am
The location is not that important to me, and talking to MS people is nice, but not the compelling reason to go. For me, strong sessions that are well...
January 18, 2010 at 11:01 am
The key to being successful in management is to make the job your own...just the right mix of technology, people and politics to keep you happy. Of course, this...
January 5, 2010 at 8:37 pm
Viewing 15 posts - 16 through 30 (of 37 total)