Posted by Piero 'Giops' Giorgi on 06/06/07 16:14

> You might consider a hybrid solution with 50 individual state tables
> included in a partitioned view, with each state table partitioned by county.
> This approach would leverage partitioning to quickly reload individual
> counties yet provide a seamless view of the entire country.

THANK YOU!
That is exactly what I want to do, but unfortunately I'm not (YET)
able to do it.

How can I have a partitioned view of partitioned tables?
I have the 50 state tables partitioned by county, but I can't get to
the next step.

Can someone post a small example of the thing?

Thanks

Piero

• Next in forum: Re: SQLServer Table Partitioning
• Prev in forum: How To Script
• Thread view: Re: SQLServer Table Partitioning

[Reply to this message]