How do I partition efficiently in SQL Server based on foreign keys?

Question

I am working on SQL Server and want to create a partition on a table. I want to base it off of a foreign key which is in another table.

table1 (
   fk uniqueidentifier,
   data
)

fk points to table2

table 2 (
    partition element here
)

I want to partition table1 base on table2's data, ie if table2 contains categories

Answer 1

The foreign key relationship doesn't really matter, horizontal partitioning is based on the values in the table itself. The foreign key just makes sure they already exist in another table.

Links:

• SQL SERVER – 2005 – Database Table Partitioning Tutorial – How to Horizontal Partition Database Table
• Partitioning a SQL Server Database Table
• Steps for Creating Partitioned Tables