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 |
|
amsqlguy
Yak Posting Veteran
89 Posts |
 Posted - 2009-06-17 : 11:24:16
|
| Guys,I have a 60 million row table which I split into a file group that has 4 files. This has improved the performance drastically, I also went a stepfurther and split the clustered index into file group with 4 files. One question that still lingers how is splitting data into file groups different thanpartitioning using partition functions. When the table's data is split into file groups how does the SQL engine decide which row goes into which file wihtin the file group.Any suggestions and inputs would help.Thanks |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2009-06-17 : 11:27:38
|
| Think it just allocates extents when needed to keep the files a similar size. Within that it will allocate rows to pages within the extents as usual.That's just a guess - could be wrong.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Splitting data into file groups vs partitioning