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?
- 0 Answers
- 850 Views
- I also Faced
- E-Mail Answers
How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?
How to create a Master database in SQL server ?
Do you know query execution plan?
What is sql stored procedure?
What is the purpose of using COLLATE in a query?
What is the difference between a stored procedure and a user defined function in sql server?
How do I run sql server 2014?
CREATE a table from another table
What stored by the model?
How do you troubleshoot errors in a SQL Server Agent Job?
How does recursive cte works in sql server?
How do I view a procedure in sql server?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
