I have a time base partition with Year2004 and Year2005. When
processing Year2005 the processing time is getting longer to aggregate.
To have it process faster should i break the partition into quarters?
For example: 2005qtr1 2005qtr2? Or will this still take the same
amount of time aggregate since it still hast to aggregate the entire
year for 2005?

The more partitions you create, the shorter the processing time is for each
individual partition. But the more time to manage the larger number of
objects. It is not uncommon for large systems to partition at the weekly or
monthly level.

Once you have lots of partitions, you might want to look at something like
this utility to process them in parallel.
http://www.microsoft.com/downloads/d...DisplayLang=en
BTW: with SQL Server 2005, processing of objects in parallel is done by
default and the utility won't be needed.

Hope that helps.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

<ricocali (AT) hotmail (DOT) com> wrote