so I have tested, if it accepts values.

Used below to alter to include new boundary values.

ALTER PARTITION SCHEME [ps_Historical_FCM_Test] NEXT USED [PRIMARY]

GO

ALTER PARTITION FUNCTION [pf_Historical_FCM_Test]() SPLIT RANGE(20081130)

GO

The new...

Thanks for your response Scott, [hist_row_id] acts as a Primary key for that table, so acts a Clustered Index anyway.

And today it has 34M may not look many, but...

ok, The existing PF and PS has dependency with other tables which are in the DB, and they are active today.

If I go ahead try to alter or Drop and...

:), here it goes.

Below is the PF i was using earlier, if you see the oldest day available is 20081231. Now the requirement is to extend this for all...

Thanks for all your information and time today, highly appreciate it.

I will reconvene if at all I am stuck or need more info.

Thanks again, have a nice eve...

Does this work out? Please correct me if there is any modification. my aim is to remove any partition and compressions on this table HISTORICAL_Test.

CREATE CLUSTERED INDEX [IX_AS_OF_TS] ON [CREDIT_RW].[HISTORICAL_Test]...

Thankyou.

What if I want to drop the parition I have just created on this table?

Could you please give me the steps. Such a way I have my orginal table without...

ok, Thanks for your clarification.

I have seen Page compression being used in couple of other tables in the DB am working on.

Having created the Partition on this table, do...

I guess this should work if am correct? if this is correct, still have the confusion on ONLINE =ON, what is it doing?

CREATE CLUSTERED INDEX [IX_AS_OF_TS] ON [HISTORICAL_Test]

(

[AS_OF_TS]

)WITH (SORT_IN_TEMPDB =...

Thanks, now that I understood what exactly is going on.

I had ran thae 3rd part alone and it has created a clustered index. The index name looks clumsy like...

Thanks Much, So you recommend to create a Clustered index on the PS?

The below script is generated through wizard, if I provide this to DBA, will he be able...

Thank you, I have used an existing Partition function and Scheme.

I could create the partitions.

Wondering what is this Index creation, I see Null when I pull the report for this...

Hi,

Untill yest i was trying to give connectiontimeout not commandtimout.

I have set the cmd.Commandtimout to 300 and its working gr88...

All,

Thanks for your help. I could at last call SSIS...

Hi Harsh,

Thanks for your note..

Untill yest i was trying to give connectiontimeout not commandtimout.

I have set the cmd.Commandtimout to 300 and its working gr88...

All,

Thanks for your help. I could...

Hi Lynn,

So here is the good news.

I could create a Sp which executes the Job and also wait untill the job is run success. I have executes this proc in...