Posted by Erland Sommarskog on 04/29/07 21:19

Dan Guzman (guzmanda@nospam-online.sbcglobal.net) writes:
> It is possible to move a non-partitioned table (actually a single
> partition) into a partitioned table with ALTER TABLE...SWITCH PARTITION.
> The source/target table must have the same schema (including indexes)
> and table/indexes must reside on the same , filegroup(s). Also, the
> source table must have a check constraint on the partitioning column to
> ensure data is within the target partition boundaries.


Ah, that's great. That would it would be possible for Bjørn to create his
partitions with SELECT INTO, add the required index and constraints nd
then glue them together.

Thanks Dan for the information. ... I really need to start playing with
partitioning some day.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Transform/transfer 50Gb - how to do it fast?
• Prev in forum: Re: Transform/transfer 50Gb - how to do it fast?
• Thread view: Re: Transform/transfer 50Gb - how to do it fast?

[Reply to this message]