Exactly,

I have to use the primary key in the primary partition.

There will be a performance gain?

Thanks Paul.

Luis.

Can I create PK integer (nonclustered) and the partition function datetime?

Partition Function:

CREATE PARTITION FUNCTION pf_Date (datetime) AS

RANGE right FOR VALUES (2007-01-01', '2008-01-01', '2009-01-01' );

GO

Partition Scheme:

CREATE PARTITION SCHEME ps_Date...

Tks replay

Do you help me in sytax?

This sintax is wrong:

CREATE TABLE Sales (

SalesID int not null

SalesDate datetime not null

CONSTRAINT...

Tks replay

Do you help me in sytax?

This sintax is wrong:

CREATE TABLE Sales (

SalesID int not null

SalesDate datetime not null

CONSTRAINT...

Perfect.

thanks.

Thanks for the reply.

What is the syntax for Convert a table is not partitioned on a partitioned table using switch

I will use horizontal partition by fiscal year.

Tks

Luis