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 |
|
hspatil31
Posting Yak Master
182 Posts |
 Posted - 2011-08-11 : 06:40:26
|
| Dear All,I am having one table with the milions of records. In that on ID field I sets the primary key with the newID().I want to do the partitions on this table. Can anbody please tell me how to do the partitions on the table.Thanks and Regard'sHarish Patil |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-08-11 : 08:07:37
|
| Uniqueidentifier is usually a poor choice for a primary key.How to partition is up to you. do you have a date column, or some other logical key to partition on? |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
Partition on table.