Partitioning Data for Master child Relationship tables
How is partition implemented in sql server 2008 on the tables that have master record and child record related to it. For example : schedule : (schduleID, Startdate, enddate) scheduleData : (ScheduleID, hour, values)-- 24 hr data I want to implment partitioning on this kind of datastructure based on the startdate. How to achieve it. Thanks.