SQL Server 2005 Partition table by foreign referenced data -

is there canonical way partition table referenced info table?

for example

timetable id datetime bigtable id timetable_id -- foreign key .. other info ..

i want partition bigtable datetime in timetable. thankx.

as noted here, partitioning column must part of unique indexes on table, include primary key.

i think selection here denormalize timetable.datetime column bigtable column available partitioning.

sql-server sql-server-2005 partitioning

Five