September 20, 2016 at 10:29 pm
I have a table which has 200 columns and 1 million records. I need to create SP which can fetch data in row wise manner. Also there will be 15-20 threads in .net application which use this SP. May i know what is best approach to achieve it. I think there will be issue with locking as well. here i am attach script for create source and destination table. In source there is two columns flag and status. once data load successfully then it will be 1 else 0 and status like not started,in progress, complete that will get from application.
Appreciate your help.
September 21, 2016 at 5:48 am
Please don't post multiple threads for the same question.
No further replies here please. Replies to http://www.sqlservercentral.com/Forums/Topic1819483-3740-1.aspx
As I said in the other thread, I would recommend you not use .net, not use multiple threads, not run the process 1 row at a time.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply