Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sent_sara
Constraint Violating Yak Guru
377 Posts |
 Posted - 2013-08-02 : 14:30:39
|
| Hi,Just Analysing the Performance for insertion of 2 million records into partioning and non-partitioning table.In partitioning Table it took long time to insert when compare to non partitioning. can i know what is the process behind goeswhile inserting rows into partioning table? |
|
|
MuMu88
Aged Yak Warrior
549 Posts |
Posted - 2013-08-02 : 19:54:34
|
| As per BOL:"Partition function A database object that defines how the rows of a table or index are mapped to a set of partitions based on the values of certain column, called a partitioning column. That is, the partition function defines the number of partitions that the table will have and how the boundaries of the partitions are defined. For example, given a table that contains sales order data, you may want to partition the table into twelve (monthly) partitions based on a datetime column such as a sales date."You can read more here:http://msdn.microsoft.com/en-us/library/ms190787.aspx |
 |
|
|
|
|
|
Insert into Table Partitioning