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 |
|
Norwich
Posting Yak Master
158 Posts |
 Posted - 2006-04-18 : 09:53:02
|
| HiIf I have a table in Yukon and I have table partitions ON and Index partitioning on and I switch data OUT of a the partitioned table - If I use alphabetical ranges and I switch OUT range 'E' to 'H' won't that leave a hole in my partition domain? As far as I know you can't have holes in your partion domains. Or are the partitions done at Meta Data level and the switching will not affect partitioning function? Or is the "Holes" only relevent when you are creating the partitioning function?I know that the switching is done at Meta Data levelThe revolution won't be televised! |
|
|
mmarovic
Aged Yak Warrior
518 Posts |
Posted - 2006-04-18 : 10:43:45
|
| You can't have overlaps, but you should have no problem with holes IMO. However, I haven't worked with partitions on sql 2005, so I may be wrong. |
 |
|
|
Norwich
Posting Yak Master
158 Posts |
Posted - 2006-04-19 : 02:47:57
|
| According to one of the webcasts, you can't have holes in your partition domain.I thought about it some more last night and I came up with the following:You have partitioned table with partitioned indexes (which are aligned). If you switch data out say at the end of every month. You will have Holes in your tables scheme. So I think the "No Holes" rule is when you are creating the partition function.I want to start using it but I want understand all the facts around it before implementing itThe revolution won't be televised! |
|
|
|
|
|
|
Partitioned Indexes and Tables