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 are the limitations of parameters in a storedprocedure
How check triggers in sql server?
Explain “@@rowcount” and “@@error” in sql server?
What are the different SQL Server Versions you have worked on?
What is the stuff?
To automatically record the time on which the data was modified in a table, which data type should you choose for the column?
Is there any difference between the primary key and unique key?
Can you tell me the difference between DELETE & TRUNCATE commands?
What is constraints and its types?
Is sql server difficult to learn?
hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail
can you any body tell me while running BCP Out in instance in sql server 2000 is getting error. Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.?
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)