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?
1190After removing a table from database, what other related objects have to be dropped explicitly?
1101
What is the command to change the recovery model?
How to create new databases with "create database" statements?
How to replace the Query Result 'Null Value' with a text ?
What causes index fragmentation?
What is the default schema of your login session in ms sql server?
What is the default fill factor value?
What are tables in sql server?
How do I find the query plan in sql server?
What is the use of custom fields in report?
How to create view in stored procedure sql server?
what are the different types of replication you can set up in sql server? : Sql server database administration
What is the security model used in sql server 2005?
where can you add custom error messages to sql server? : Sql server administration
which table keeps the locking information? : Sql server administration
What do you mean by an execution plan? Why is it used?