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 delete a login name in ms sql server?
how to improve the speed of SQL database server and how to avoid dead lock?
What is unique key constraint?
which query u can write to sql server doesn't work inbetween 7.00PM to nextday 9.00AM
What is buffer cash and log cache in sql server?
What are the steps you will take to improve performance of a poor performing query?
what is the difference between sql query and google query?
What is RMS migrations?
What is a raid and what are different types of raid configurations?
How to handle errors in Stored Procedures.
What is a job?
How cand Optimize SQL Server Stored Procedures
Oracle (3259)
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)