• One thing I saw on MSDN and worth noting:

    "Because the leaf level of a clustered index and the data pages are the same by definition, creating a clustered index and using the ON partition_scheme_name or ON filegroup_name clause effectively moves a table from the filegroup on which the table was created to the new partition scheme or filegroup. Before creating tables or indexes on specific filegroups, verify which filegroups are available and that they have enough empty space for the index. "

    http://msdn.microsoft.com/en-us/library/ms188783.aspx

    ---

    ----------------------------------------------------