CODEWITHSUNDEEP
sql-servert-sqlindexingpartitioningdatabase-administration
SamFenton
SamFenton

Reputation: 33

Drop Partitions SQL Server 2008

I have to migrate SQL Sever 2008 database to the SQL Server 2012. 2008 is the enterprise version and 2012 is standard version. As we know, standard version does not support table partitioning.

The table which is partitioned in the enterprise version has 1 clustered and around 8 non-clustered indexed. I need to drop this partition but do not know how. Can someone please shed little light on how should I go about it?

Thanks.

Upvotes: 0

Views: 194

Answers (1)

Dan Guzman
Dan Guzman

Reputation: 46193

To unpartition a table, you'll need to recreate all the indexes with a filegroup specification instead of parttion scheme. I suggest you drop all the non-clustered indexes and then rebuild the existing partitioned clustered index using CREATE INDEX...WITH(DROP_EXISTING-ON) with a filegroup specification. Then recreate the non-clustered indexes with a filegroup specfied.

Upvotes: 1

Related Questions