Posted by Piero 'Giops' Giorgi on 06/05/07 23:59

On Jun 5, 3:24 pm, Erland Sommarskog <esq...@sommarskog.se> wrote:

>> But, before trying, can I have 3077 files in ONE partition, and drop
>> all the states stuff?

> No, in the topic for CREATE PARTITION FUNCTION, I found that you
> cannot have more than 999 boundary values.

Dang it... I kew there was a catch.

So, I'll be forced to have 3077 filegroups, grouped with 50
partitions.
Is there a way to have a partition function/scheme that sees other
schemes, instead of filegroups?

I mean Filegroups Counties (3077) - grouped by state (50) - all
together in ONE partitioned table.

Any Ideas?

Thank you!

Piero

[Back to original message]