Timeline for How to insert/update millions of rows inside a sql server table(s) in an effective way?
Current License: CC BY-SA 3.0
9 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) | |
| Apr 13, 2017 at 12:43 | history | edited | CommunityBot | replaced http://dba.stackexchange.com/ with https://dba.stackexchange.com/ | |
| Oct 28, 2015 at 20:36 | history | tweeted | twitter.com/StackDBAs/status/659468865060118528 | ||
| Oct 28, 2015 at 18:00 | vote | accept | Marcello Miorelli | ||
| Oct 28, 2015 at 16:50 | answer | added | Solomon Rutzky | timeline score: 4 | |
| Oct 28, 2015 at 16:35 | comment | added | qxotk | Here's an article on Transaction Log that might guide you in terms of whether to use multiple batch-sized transactions or not. For example, if you use the smaller transactions, your log might perform better. msdn.microsoft.com/en-us/library/ms190925%28v=sql.120%29.aspx | |
| Oct 28, 2015 at 16:27 | comment | added | Marcello Miorelli | mostly I am running on sql 2014, but unfortunately I still have some core systems running on sql 2005, and these are not likely to be upgraded until late 2016. | |
| Oct 28, 2015 at 16:17 | history | edited | Marcello Miorelli | CC BY-SA 3.0 | added 238 characters in body |
| Oct 28, 2015 at 15:28 | history | asked | Marcello Miorelli | CC BY-SA 3.0 |