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?
1194After removing a table from database, what other related objects have to be dropped explicitly?
1108
What is the difference in accessing db between sql server vs sql azure?
what is a self join? Explain it with an example? : Sql server database administration
What is a natural primary key?
What is sub-query in sql server?
What does nvl stand for?
What are basics of policy management?
What are the functions in sql server?
Why use update_statistics command in sql server?
How to insert multiple rows with one insert statement in ms sql server?
Can we use where clause in union?
What are the purpose of Normalisation?
What are the new features are introduced in sql server 2012 reporting services?
Explain the xml support sql server extends?
How to grant a permission in ms sql server using "grant execute" statements?
What are different types of data sources?