Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
JimboWin
Starting Member
1 Post |
 Posted - 2010-09-13 : 08:30:36
|
| Hi,I am planning to use partitioning to store historic data on a monthly basis.I would like to overwrite data each year so that there are only 12 partitions at any one time (January - December).What would be the most efficient way of doing this? Or if partitioning is a bad option for my scenario, what would be better (i.e store everything in same table, or seperate table for each month etc)?Regards, |
|
|
|
|
|
Partitioning questions