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 |
|
scelamko
Constraint Violating Yak Guru
309 Posts |
 Posted - 2010-01-22 : 15:46:21
|
| Guys,I have 40 million row table, I would like to create a partition function based on ID where when ID between 1 to 20mill goes to filegroup1, 20mill to 40mill does to filegroup2 and anything > 40mill goes tofilegroup3. How can this be accomplished without purging and reloading data. One way to move data across multiple files in a filegorup without purgin/reloading is by recreating the clustered on filegroup, but I am not sure how this can be accomplished with partition function without purging and reloading existing data. Any suggestions/inputs would help.Thanks |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-01-22 : 17:37:25
|
| create the clustered index on the partition function. BOL has syntax and sample statements: http://msdn.microsoft.com/en-us/library/ms188783.aspx |
 |
|
|
|
|
|
Partition Function