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 |
|
koushikchandra
Starting Member
24 Posts |
 Posted - 2011-02-01 : 02:52:43
|
| Hi,I want to have a scenario where a table will have partitions on Monthly basis (partition will be there based on a Time column). At the end of every month a new partition will be created for the next upcoming month and 25th months' oldest partition will be moved in a different file group and will be compressed.Can you please provide a sample script for creating the table with partitions and a sample script for creating and moving partition in different file group.Regards,Koushik |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2011-02-01 : 05:32:02
|
| What have you done so far on your own? Partitioning requires careful planning and you'll probably be better off figuring this one out for yourself. There are many variables to take in to consideration...Here is a great place to start: http://msdn.microsoft.com/en-us/library/ms188706.aspx- LumbagoMy blog-> www.thefirstsql.com |
 |
|
|
|
|
|
Moving table partition in different file group