Question to consider:
> which column is likely to be used in range-based searches (usually the column with the clustered index)?
This would be the column to effect the partition on, e.g. using range left for customer for values 1000, 2000, 3000 etc
> how many filegroups and physical files would be required (to split the data accross numerous drives, if applicable)?
____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”