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 select true false based on column value in sql server?
Why is DML provided?
1 Answers Ernst Young, Thomson Reuters,
What is sqlservr.exe - process - sql server (sqlex?press)?
Explain what are the restrictions that views have to follow? : SQL Server Architecture
What is a trigger and its types?
What is difference between view and materialized view?
any one can explain Self mapping Delegation Remote Credentials
What do you understand by recursive stored procedure?
What is use of attribute hierarchy ordered ? : sql server analysis services, ssas
What is the difference between a fill factor of 100 and 0?
What is tempdb in sql server?
what is physical sort data and logical sort data in index?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)