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?

0 Answers  

---

Explain how dts is used to extract, transform and consolidate data?

0 Answers  

---

How can delete duplicate records in cte in sql server?

0 Answers  

---

What is the difference between an index and a unique index?

0 Answers  

---

What is built-in function?

0 Answers  

---

---

What are the different Authentication modes in SQL Server and how can you change authentication mode?

0 Answers  

---

What are logical database components? : SQL Server Architecture

0 Answers  

---

How to create stored procedures with parameters in ms sql server?

0 Answers  

---

What do you understand by integration services in sql server?

0 Answers  

---

What is live lock and deadlock? what is Lock escalation?

2 Answers   Microsoft,

---

what are defaults? Is there a column to which a default can't be bound? : Sql server database administration

0 Answers  

---

sql server syntax to add "!" sign to "name" field of "employee" table in a manner that all names have the same lenght of 20 characters

1 Answers  

---