Viewing 7 posts - 16 through 23 (of 23 total)
20+ years as a technology professional, so just guess my answer to this question. PLEEEEEEAAAAASE. Are you kidding me?
[font="System"]Jay Quincy Allen, Managing Partner, Relational Models LLC[/font]
February 16, 2012 at 10:55 pm
You're right, I took this away from the original topic and it would be better served in another forum. I understand that many say "it's the best", not to...
[font="System"]Jay Quincy Allen, Managing Partner, Relational Models LLC[/font]
December 21, 2011 at 12:58 pm
Frank, why would that be considered best practice? A temporal relational data warehouse in database tables captures more data than a dimensional model, has a lower footprint on disk,...
[font="System"]Jay Quincy Allen, Managing Partner, Relational Models LLC[/font]
December 21, 2011 at 7:00 am
Why would you implement a dimensional model in SQL Server database tables instead of Analysis Services?
[font="System"]Jay Quincy Allen, Managing Partner, Relational Models LLC[/font]
December 20, 2011 at 8:11 am
Yes, sorry Jeffrey, a heap index, not a hash.
[font="System"]Jay Quincy Allen, Managing Partner, Relational Models LLC[/font]
January 2, 2011 at 7:14 pm
Someone mentioned in an earlier post that all tables must have a cluster definition. This is not true. It's called a hash table.
[font="System"]Jay Quincy Allen, Managing Partner, Relational Models LLC[/font]
January 2, 2011 at 1:33 pm
Solomon,
Great article. I used to get very frustrated with programmers AND DBA's that thought the normalization aspects of relational models would cause a degredation in performance. I know...
[font="System"]Jay Quincy Allen, Managing Partner, Relational Models LLC[/font]
December 30, 2010 at 11:55 pm
Viewing 7 posts - 16 through 23 (of 23 total)