I have a quick question regarding merging cube partitions.
If I create partitions sliced by date (let's assume we have year level partitions like 2006,2007,2008...)
Later, if I want to merge selected partition to another partition , for example I have history partition and 2006 partition and I want to merge 2006 to history partition then I can simply merge themÃÂ using ' merge partition'ÃÂ through Management Studio.
My question is thatÃÂ in script,ÃÂ HistoryÃÂ partition has condition which is where clause and restricted by year level (i.g. WHERE date < '01-01-2006' ) ; however after merging , script won't change like WHERE date <'01-01-2007').
If so, whenever I merge partitions then I have toÃÂ alter the script as well based on selected merge partion?
IÃÂ need to refresh history partition once a month;however even if I merge 2006 partition , once I reprocess history partition then it only process what it was wrote in script. So, after reprocessing 2006 data won't appear in this history partition.
So, wondering it's mentatory to alter the scriptÃÂ once partition is merged.
Please give me some comments on this issue
View Complete Post