I have i doubt

when I recreated an index using this script ,I found 1 difference in FILLFACTOR value in case of '0'

----------------------------------------------

This is what I generated before this script

----------------------------------------------

CREATE...

This is really good example.

But i have a heavy loaded table on which i need to implement this.

So from your example instead of 'create table' can anyone suggest me how...

Hi Abhay,

as you said we need to mentioned the partition schema while declaring the table as shown below :-

CREATE TABLE [dbo].[fact_warehouse_transaction]( [transaction_ident] [int] NOT NULL IDENTITY(1, 1), ...

Regarding partitioned Index :-

One more thing if suppose there is a table A, having primary key over column 'A1'

,this contains 700 columns and out of these 15 columns...

Thanks for reply.

i read these articles.

But still it is better if someone guide me by providing some precise and step by step details to partition a table in an existing...