cncjay
Well Known Member
Hello All,
Wanted to get feedback, if anyone using Microsoft SQL server 2008R2 successfully implemented its table partitioning feature for E1 tables ?
We are considering it versus Arctools. The concern we have with Arctools that it involves business analysts to clean up the data and address orphan records concern. While both of these concerns are legitimate, we don't have the bandwidth and the time for this type of analysis.
Simply put, it will be much easier and quicker to move older data (using date criteria or something similar) to another partition.
Any feedback on this will certainly be of great help.
Regards,
CNCjay
Wanted to get feedback, if anyone using Microsoft SQL server 2008R2 successfully implemented its table partitioning feature for E1 tables ?
We are considering it versus Arctools. The concern we have with Arctools that it involves business analysts to clean up the data and address orphan records concern. While both of these concerns are legitimate, we don't have the bandwidth and the time for this type of analysis.
Simply put, it will be much easier and quicker to move older data (using date criteria or something similar) to another partition.
Any feedback on this will certainly be of great help.
Regards,
CNCjay