Timeline for What is the fastest way to insert large numbers of rows?
Current License: CC BY-SA 3.0
13 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 7, 2020 at 22:23 | history | edited | CommunityBot | added [query-performance] to 2412 questions - Shog9 (Id=1924) | |
| May 5, 2019 at 20:33 | history | edited | Aaron Bertrand | edited tags | |
| Feb 27, 2014 at 16:04 | answer | added | Zane | timeline score: 12 | |
| Feb 27, 2014 at 15:51 | comment | added | Zane | If you're using SSIS what is the rows per batch that you have set and the maximum insert commit size? | |
| Feb 25, 2014 at 14:11 | vote | accept | nojetlag | ||
| Feb 19, 2014 at 16:40 | history | tweeted | twitter.com/#!/StackDBAs/status/436178441562755072 | ||
| Feb 19, 2014 at 16:34 | comment | added | nojetlag | @Kin had a look at the guide but it seems outdated, "The SQL Server destination is the fastest way to bulk load data from an Integration Services data flow to SQL Server. This destination supports all the bulk load options of SQL Server – except ROWS_PER_BATCH." and in SSIS 2012 they recommend the OLE DB destination for better performance. | |
| Feb 19, 2014 at 16:32 | comment | added | Aaron Bertrand | Yeah I really meant "sets of disks" and probably could have mentioned controllers too, which can get saturated. | |
| Feb 19, 2014 at 16:30 | comment | added | nojetlag | @Aaron yes, per month one filegroup, 12 san lun's attached so all jan go on one lun etc. Not sure how many disks per lun but should be plenty. | |
| Feb 19, 2014 at 15:17 | comment | added | Kin Shah | A really good resource The Data Loading Performance Guide. This addresses a lot of performance optimization you can do e.g Enabling TF610, Using BCP OUT/IN, SSIS etc. You just have to follow the recommendations and test it out in your environment. | |
| Feb 19, 2014 at 14:57 | answer | added | Aaron Bertrand | timeline score: 27 | |
| Feb 19, 2014 at 14:44 | comment | added | Aaron Bertrand | Are the partitions on separate filegroups (and are on those filegroups on different physical disks)? | |
| Feb 19, 2014 at 14:28 | history | asked | nojetlag | CC BY-SA 3.0 |