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?

643

What is the report builder?

106

What is coalesce and check constraint in sql server?

535

do views contain data ?

574

what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration

513

What is usually the first word in a sql query?

589

What are the two authentication modes in sql server?

594

what stored procedure can you use to display the current processes? : Sql server administration

524

Why we use functions in sql server?

511

Can you explain the disadvantages/limitation of the cursor?

497

How to use old values to define new values in update statements in ms sql server?

673

How to check if a table is being used in sql server?

506

How can I create a report based on a query? : sql server management studio

552

what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration

492

How to create user messages with print statements in ms sql server?

588