DW Schema? said...Tim:
Would this work for a data warehouse? Fact tables could get their partitioning from a Date dimension table... but that would mean partitioning the date dimension which is usually very small: preloaded with several years of data. Unnecessary overhead on the Date dimension unless the partitioned join would be worth it. Thoughts?
The example in this article is only to show the interval reference partitioning feature in action. It's not a recommendation of how to partition a table.
DO NOT ask technical questions here! They will be deleted!
These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!
If you post personal information (name, email address etc.) you are agreeing to them being stored and displayed. Feel free to remain anonymous.