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 |
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
 Posted - 2008-05-16 : 15:55:02
|
| Am I correct in assuming, in partitioning scenarion - the NUMBER OF PARAMETERS in a partitioning function is equal to number of file groups?------------------------I think, therefore I am - Rene Descartes |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-16 : 15:59:04
|
| It depends.It's better to put each partition in seperate FG in separate disk so you will gain performance. |
 |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2008-05-16 : 16:09:44
|
| Can a filegroup contain multiple partitions?------------------------I think, therefore I am - Rene Descartes |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-16 : 16:11:22
|
| Yes. |
|
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2008-05-16 : 16:18:13
|
| So, In CREATE PARTITION SCHEME - can I have duplicate FILE GROUP names?------------------------I think, therefore I am - Rene Descartes |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-16 : 16:26:24
|
| Yes you can have. |
|
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2008-05-16 : 16:33:37
|
| OKAY!I am clear now. There is no magic!------------------------I think, therefore I am - Rene Descartes |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-16 : 16:36:49
|
| you really need to read this.Here is really good whitepaper on Table Partitioning:http://www.sqlskills.com/resources/Whitepapers/Partitioning%20in%20SQL%20Server%202005%20Beta%20II.htm |
|
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2008-05-16 : 16:40:41
|
| I have that link in my favorites for sometime now. I will read it sometime soon. Is it really good? It's huge...------------------------I think, therefore I am - Rene Descartes |
|
|
|
|
|
|
Partition function and file group