Hi:

SQL 2005 sp2 Ent. Need to partition on some large tables.
Issues:

1. Could we defined multiple functions for different range, and apply them to one table?

2. The target table must provide unique key. Now, it is a composite pk with 4 fields together. How can I define the uniqe range for them?

3. All mdf files are on E:\SQL_Data, which is SAN. how could I declare file groups on the same E:\ drive?

4. Even if above are resolved, how can I convert existing tables to the new partitioned tables, or I don't need to do so?

5. All all the fk relationships still carried over?

Thanks for the help
David