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 |
|
noonz
Starting Member
33 Posts |
 Posted - 2010-04-26 : 14:40:01
|
| Hello all,I am studying for my MCTS in SQL 2008 and I am now on Chapter 6 of Mike Hotek's Book.Chapter 6 focuses on Distributing and Partitioning Data,The first part of this Chapter discusses Partition Functions, but I am having an extremely difficult time understanding what this means."A partition function defines the boundry points that will be used to split data across a partition scheme".It then gives a table, like|ID| |c1| |c2| |c3||1 | |3 | |A | | | -> Filegroup1|2 | |5 | |B | | | -> Filegroup2|3 | |2 | |B | | | -> Filegroup1|4 | |1 | |L | | | -> Filegroup4I don't understand this at all, not a very easy chapter for people pretty new to MS SQL underlying data.If someone could give me a better explanation of this and partitioning data in general so I could understand this better I would greatly appreciate it. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
noonz
Starting Member
33 Posts |
Posted - 2010-04-26 : 16:58:27
|
| Hello Peso,Partition Function |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2010-04-27 : 00:24:22
|
Partition function is there to decide which partition which data goes.According to your PF, you can set left or right ranges to split the data into your partitions.
N 56°04'39.26"E 12°55'05.63" |
|
|
|
|
|
|
Easier Explanation of Partitioning Tables