You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
No Answer is Posted For this Question
Be the First to Post Answer
How to stop log file growing too big?
How many primary keys are possible in a table?
How will you make an attribute not process? : sql server analysis services, ssas
Tell me what is a linked server?
What are the advantages of paper records?
How to enter comments in transact-sql statements?
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
What is user defined datatypes and when you should go for them?
Explain concepts of analysis services?
How to convert numeric values to integers in ms sql server?
What is the maximum number of instances in 32 bit and 64 bit sql server 2012?
What are the different types of joins and what does each do?