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
- 653 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
How do you find the error, how can you know the number of rows effected by last SQL statement?
Give me a SQL Query to find out the second largest company?
What are the benefits of using stored procedures over sql statements?
What is check constraint in sql server?
What do you understand by recursive stored procedures?
how can you check the level of fragmentation on a table? : Sql server administration
Explain different types of Normalization.
0 Answers HPCL, Hughes Systique Corporation, Ittiam Systems,
How to change the name of a database user?
What are transactions in sql?
what is hash table
Explain insert into select statement?
How to write a query with an inner join in ms sql server?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
