24 reputation
7
bio website bit.ly/sameer
location Bangalore, India
age 33
visits member for 1 year, 11 months
seen Mar 4 at 11:41

Sep
22
awarded  Popular Question
Mar
4
revised Improve Insert performance for 200 Million rows
edited tags
Feb
28
awarded  Commentator
Feb
28
comment Improve Insert performance for 200 Million rows
indexes are updated in the actual upload that i've uploaded just now.
Feb
28
comment Improve Insert performance for 200 Million rows
Actual plan here: dropbox.com/s/hszlwvkxv1s8doi/od_itemcost3_Execution%20plan.xml
Feb
28
revised Improve Insert performance for 200 Million rows
deleted 37 characters in body
Feb
28
revised Improve Insert performance for 200 Million rows
deleted 257 characters in body; edited title
Feb
3
comment Improve Insert performance for 200 Million rows
Updated plan and dm_exec_requests during run in the question above.
Feb
3
revised Improve Insert performance for 200 Million rows
added 115 characters in body
Feb
3
revised Improve Insert performance for 200 Million rows
added 138 characters in body
Feb
2
asked Improve Insert performance for 200 Million rows
Jan
27
comment Slow insert - 300+ Million Records
Will check and post dm exec requests/os waiting tasks tomorrow. Have temporarily bumped up the pre-allocated space from 430G to 500G for the mdf.
Jan
27
comment Slow insert - 300+ Million Records
auto-growth is set to 20%, and several tables in the db are truncated and loaded each day.. so i assuming there is space. Otherwise, any pointers to double-check or change the same? (unless you are referring to mdf ldf sizes.. which i know where to check)
Jan
27
comment Slow insert - 300+ Million Records
Completes about 150M rows in ~10mins, but takes another 20mins for the other 150M.
Jan
27
comment Slow insert - 300+ Million Records
The function SAPLeading0s just removes 0s at the beginning. Similar to cast as int/bigint but not be converted. Column needs to remain as text.
Jan
27
revised Slow insert - 300+ Million Records
edited tags
Jan
27
asked Slow insert - 300+ Million Records
Jun
3
awarded  Supporter
Jan
5
awarded  Editor
Jan
5
revised How can I capture queries that fail on the SQL Server due to connection failures?
added 376 characters in body