Originally posted by byrmol
It has WAITFOR.. but honestly, if you think you can write code that handles load better than the engine, you are a brave man.....
Thanks for your reply.
As the matter of the fact, because I have a data transfer from text file to db, and the file is very big.
Then it spend me a lot of time to insert, and at the moment, the client still query the db.
That's why I want to split the process, or the user will complain about the query performance.
Would you please advise me if sql server can set the priority level of specific account, if I can down grade the priority of data transfer program, then I will not use the waitfor function to control the loading.