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 |
|
kkiranvr
Yak Posting Veteran
54 Posts |
 Posted - 2008-07-11 : 00:49:16
|
| I am doing dynamic partitioning to a table, i have created Partition function, Partition Scheme and created table with Partion scheme on a perticular column, so my Partitioning is working like a dream, NowMy question here is how to do dynamic partitioning? Means, I need to get rid of data after 90 days, but i need to maintain my partitioning alive.-Thanks N Regards,Kanthi. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-11 : 23:39:04
|
| Books online has that, you need put each partition in its own file group. |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-12 : 11:06:38
|
| You can use switch out and merge. |
|
|
|
maninder
Posting Yak Master
100 Posts |
|
|
|
|
|
Dynamic Partition