20+ years as a technology professional, so just guess my answer to this question. PLEEEEEEAAAAASE. Are you kidding me?

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...

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,...

Why would you implement a dimensional model in SQL Server database tables instead of Analysis Services?

Yes, sorry Jeffrey, a heap index, not a hash.

Someone mentioned in an earlier post that all tables must have a cluster definition. This is not true. It's called a hash table.

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...