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
Define cross join in sql server joins?
How many triggers are possible per table?
How do you implement session management in SQL Server mode?
What are the advantages of using stored procedures?
What are different types of raid levels?
What does the update command do?
what is meant by deafult in sql server?
tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
What is simple indexing method?
Explain different forms of normalization?
Explain difference between control flow and data flow?
you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration
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)