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
What is resource db in sql server?
What are the recovery models in sql server 2000?
Explain intellisense for query editing
What are types of storage modes? : sql server analysis services, ssas
What is a heap?
How to get nth highest salary from employee table.
What should be the fill factor for indexes created on tables? : sql server database administration
How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?
How do I delete a sql server database?
How to call stored procedure using http soap?
What is an Index?
How to select true false based on column value 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)