Update Table Partitions.

Question

Update Table Partitions.

nitin.varshney

SSC Eights!

Points: 948
More actions
October 7, 2013 at 3:11 am

#283459

To update the table partitions, is it suffies to drop and recreate the cluster Index on that table with the new partition Schema.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Bhuvnesh SSC Guru Points: 59351 More actions · Answer 1

nitin.varshney (10/7/2013)
To update the table partitions, is it suffies to drop and recreate the cluster Index on that table with the new partition Schema.

When querying data or performing updates, there is no difference in the way you reference a partitioned table versus a table that is not partitioned.

-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

nitin.varshney SSC Eights! Points: 948 More actions · Answer 2

Hi Bhuvnesh,

I just want to know the table partiton update, not about performing the query.

Thanks & Regards

Nitin Varshney

Bhuvnesh SSC Guru Points: 59351 More actions · Answer 3

nitin.varshney (10/7/2013)
I just want to know the table partiton update, not about performing the query.

Can you be more specific ?

-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

Update Table Partitions.

Cookies on SQLServerCentral