SQL Server 2005 Partitioned Tables

[sendba]

All

I have a table which contains 600 Million records.
I would like to partition this table so that the partition will contain 50 Million records in each.

My question is
* Can i build the Primary key index on each and every partiion if so please let me know the syntax.
* Can i rebuilt the primary key index on individual partitions

Please help

thanks in advance

Sen

 

[mrdenny]

As all the partitions are part of a single table the primary key covers the entire table. As do other indexes.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com