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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2007-01-08 : 08:02:41
|
| Ananth writes "A new feature is established in SQL Server 2005. That is Partitioned Table. I went through several articles in net regarding partioned table. But I did not get any generalized version of Partitioning.For example I partitioned a table into 4 Filegroups based on Transaction Date. So I used range function to give ranges for 4 quarters of one year. It works fine. But I would like to generalize this scenario. It will work for one year. If new year comes ,I have to write new script and execute the same. The Partitioned function should work for 12 months in a given year. So here year is the paramter and then that function should be construct based on the year automatically.Can anybody give me answer asap." |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2007-01-09 : 00:15:43
|
| The whole point is that you use partitioning to control the location of the partitions. It can't be automated or it would just be a regular table assigned to more than one file (multiple files in a filegroup). Yes you do have to write statements to change the function each year, and that's how it is supposed to work. |
 |
|
|
|
|
|
General Partitioning in SQL Server 2005