Hi,

Just a matter of complementing our friend's answer:

How many disk do you have available to spread your files?

Why do you want to split your table? [Is it for increasing performance?]::[Is it a matter of space?]

You have also to create a Partitioned Index and not just common index to get best performance.

First of all you have to measure why you want to have the database split then we can go with further investigation.

You can see my youtube channel I have a video talking about partitioned tables

http://www.youtube.com/watch?v=HDx8XCoAw3w