Home Forums SQL Server 2008 SQL Server 2008 - General Parallel Processing RE: Parallel Processing
Greg Edwards-268690
SSC-Insane
Points: 20676
More actions
April 17, 2014 at 8:15 am
#1706778
Are you processing all dimensions first, then fact table?
And what is the performance processing 1 store at a time?
Generally, we would partition by year.
Clustered index on Business Unit, which would be similar to store.