|
|
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
Navigation:
[Reply to this message]
|