Home Forums SQL Server 2008 SQL Server 2008 Performance Tuning Sub partitions RE: Sub partitions
Sunil.Aggusher
SSC-Addicted
Points: 418
More actions
September 21, 2013 at 6:08 am
#1652131
Fair enough.
I'm going to partition the table by date and use partition switching to expedite the process of loading data. The only caveat is that I have to drop the non-clustered index (supplier), before switching partitions as it's not aligned