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 can you check the level of fragmentation on a table?
What is a non clustered primary key?
How does index makes search faster?
What is a trigger?
how to avoid cursors? : Sql server database administration
what is normalization? Explain different levels of normalization? : Sql server database administration
What is a recursive stored procedure in sql server?
What is sql profiler. What are the default templates with it? : sql server database administration
Can select statements be used on views in ms sql server?
In what version of sql server were synonyms released?
How to Update from select query in sql server?
What is the use of “join” in sql server?
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)