question

Katie 1 avatar image
Katie 1 asked

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.
sql-server-2008partitioning
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Tim avatar image
Tim answered
Partitioning is not overly complicated. You should google Kimberly Tripp and Partitioning. It will take some planning but to manage it is not that difficult. I have partitioned data using date constraints and a partitioned view and it works very well. Here are some links. [Link1 - Kimberly Tripp]( http://www.sqlskills.com/resources/whitepapers/partitioning%20in%20sql%20server%202005%20beta%20ii.htm) [Link2 - Kendra Little]( http://www.littlekendra.com/resources/partition/)
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.