Posted by Erland Sommarskog on 06/05/07 20:52

Piero 'Giops' Giorgi (giorgi.piero@gmail.com) writes:
> I already have a DB that uses partitions to divide data in US
> Counties, partitioned by state.
>
> Can I use TWO levels of partitioning?
>
> I mean... 3077 filegroups and 50 partition functions that address
> them, but can I use another function to group the 50 states?

Do I understand it correctly that you already have 50 partitions, and
now you want even more? About what size do you expect per partition?

I'm not sure that partitioning by state is the best strategy. The partition
for Californina will be a lot bigger than the ones for Alaska and Rhode
Island.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]