SQL Server Performance Forum – Threads Archive
Partitioned Tables in SQL Server 2005.
if i want to update the data in the column include in the partion is these will cause expensive operation?? example: if i define the partion create partition function YearPF(datetime)RANGE LEFT FOR VALUES (‘20000930 23:59:59.997’, ‘20001231 23:59:59.997’, ‘20010331 23:59:59.997’, ‘20010630 23:59:59.997’) after then the data in the table will update , how it will update in the partion , cause it is need to move from one partion to another thanks
BOL specifies
quote:
If reassigning one partition’s data to form a single table, the target table must already be created and it must be empty. Both the source table or partition, and the target table or partition, must reside in the same filegroup. The corresponding indexes, or index partitions, must also reside in the same filegroup. Many additional restrictions apply to switching partitions. For more information, see Transferring Data Efficiently by Using Partition Switching. table and target_table cannot be the same. target_table can be a multi-part identifier.
If reassigning one partition’s data to form a single table, the target table must already be created and it must be empty. Both the source table or partition, and the target table or partition, must reside in the same filegroup. The corresponding indexes, or index partitions, must also reside in the same filegroup. Many additional restrictions apply to switching partitions. For more information, see Transferring Data Efficiently by Using Partition Switching. table and target_table cannot be the same. target_table can be a multi-part identifier.
Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
]]>