Thanks

You mean besides that, I should check other options like indexing ,memory management,.....?

I have another question about partitioning(sorry I am not perfect at SQL).

I will be glad ,if you can help me please.

In my implicit table (with 2 fields for clustered index(primary key)),is it possible to have partition key on a field which is not the subset of index key?

when I want to create the clustered index it says:

Column 'kind' is partitioning column of the index 'PK_Trans'. Partition columns for a unique index must be a subset of the index key.

and then if I use ON [PRIAMARY] like following script,I don't have partitioning on that table any more.

ALTER TABLE [dbo].[Trans] ADD CONSTRAINT [PK_Trans] PRIMARY KEY

CLUSTERED([Number] ASC, [TransDate] ASC)WITH (

PAD_INDEX = OFF,

STATISTICS_NORECOMPUTE

= OFF,

SORT_IN_TEMPDB =

OFF,

IGNORE_DUP_KEY =

OFF,

ONLINE = OFF,

ALLOW_ROW_LOCKS

= ON,

ALLOW_PAGE_LOCKS

= ON

) ON [DB_PartitionScheme]([kind])-- or use [Primary]

GO

So how can I implement partitioning on this table with partitioning key which is defferent from index key?