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 |
|
dpais
Yak Posting Veteran
60 Posts |
 Posted - 2011-03-23 : 13:44:20
|
| i managed to split my 300 million record table and partition it into 10 different partitions and filegroups - this i did based on the fact that it is easier to manage and if setup correctly it will speed up searches.i initially has an index on 3 columns lets say (Column A,B and C) it was a Primary Clustered Key. When I partitioned the table I used column A as the Partition Key. Everything was fine until i tried to add the Primary Clustered Key back onto the Partitioned table. What it did was it took away all the Partitions from my table and put everything into the Primary filegroup.what did i do wrong ?? |
|
|
|
|
|
partitions and partition indexes