What is the difference between truncate and delete commands?
No Answer is Posted For this Question
Be the First to Post Answer
How do I create a trace in sql server?
How do you create type- insensitive operator?
what is normalization? what is denormalization?
What should be the fill factor for indexes created on tables? : sql server database administration
how can ur insert the emp table
What are SSL and TSL protocols?
What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration
What is data compression? : sql server database administration
What are the different types of locks in the database?
Where sql server user names and passwords are stored in sql server? : sql server database administration
What are indexes? When do you need to create Indexes?
4 Answers CarrizalSoft Technologies, HP,
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?
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)