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 |
|
zapouk
Starting Member
2 Posts |
 Posted - 2011-07-14 : 09:01:56
|
| I've a table with +100 million rows that I want to partition, and as I'm restricted to standard edition 2008 R2 I'm going to use a partitioned view. The four tables (currently) and the view have been setup and I'm now thinking about migrating the data. Bulk insert and bcp can't be used with partitioned views so I'm left with a standard insert into, or is there an alternative?If I have to use a single insert into statement, can I batch it in any way using a transaction to do, say 100,000 rows, then wait before doing the next batch?The tables are partitioned on a smalldatetime column that is part of the key (one table per year). |
|
|
Sachin.Nand
2937 Posts |
Posted - 2011-07-14 : 10:03:33
|
| Not sure why you want to insert the data into partitioned view.You can create a SSIS package and filter the data for the individual table for a particular year to insert the data.Also if possible do the inserts in set of batches or else your TLog file will bloat up.PBUH |
 |
|
|
|
|
|
Inserting millions of rows into a partitioned view