An error has occurred while setup was updating partition information
Also, all of your enabled non-clustered indexes must be “partition aligned” to switch a partition in.
This means the partitioning key must be part of each of those indexes.
First, it loads new fact data into a fresh, empty table named Froyo Sales Staging.
Then, they switch the single partition out of Froyo Sales Staging and into the partitioned table Froyo Sales.
Here are the big attractions for table partitioning, along with the fine print.
95% of reports run are against the most recent two months of data, and the DBA team controls and can tune the queries run by each report.
The Froyo DBA team needs to maintain only 13 months of data in the Froyo Sales table.
As a safety precaution, they prefer to keep three additional months of data online, but do not want reports to access the older data. Each night as data was loaded, reports repeatedly blocked inserts.
There was additional blocking and deletes slowed performance significantly.
To solve these problems, the Froyo team implemented table partitioning. Each night, the Froyo team loads data with an automated process.