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 |
|
albertkohl
Aged Yak Warrior
740 Posts |
 Posted - 2010-10-06 : 16:04:47
|
| is there any way to repartition a table without having to totally destroy and re-create it?lets say for example my current table is partitioned by zipcode, and i want to change it to be by date.i ask because i'm thinking about changing the database from being by zip to by the date, however as time progresses i'll have to repartition the table to split the data up evenly...just curious how the pro's handle something like this. |
|
|
albertkohl
Aged Yak Warrior
740 Posts |
Posted - 2010-10-12 : 17:53:06
|
| no love? am i basically burnt? |
 |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2010-10-13 : 02:46:32
|
| I've never done anything like this but repartitioning would necessarily case quite a lot of shifting data around. I'd probably create a new table instead partitioned using the new function and then just insert all the old data in to the new table. I would think that to change the partitioning on an existing table you would actually have to remove the partitioning and then add it again with the new function. his would involve twice the amount of moving data compared to creating a new table... But then again; I've never done this so there may be other options.- LumbagoMy blog (yes, I have a blog now! just not that much content yet) -> www.thefirstsql.com |
|
|
|
|
|
|
repartitioning a table