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  

---

What are points to remember while using the fillfactor argument?

0 Answers  

---

What is raiseerror? What is raiseerror?

0 Answers  

---

Why the trigger fires multiple times in single login?

0 Answers  

---

What is difference between cte and view?

0 Answers  

---

here id col have primary key and identity id name 1 a 2 b 3 c 4 d delete 2nd row then o/p will be id name 1 a 3 c 4 d next inssert 2nd row and i want o/p will be id name 1 a 2 e 3 c 4 d

7 Answers   IBM, TCS,

---

How to start and end transact-sql statements?

0 Answers  

---

Some queries related to SQL

0 Answers   Motorola,

---

Can you explain the types of Joins that we can have with Sql Server?

2 Answers  

---

Following are some of the question related to below mentioned query? select e1.salary from employee3 e1 where 2= ( select count(distinct(e2.salary)) from employee3 e2 where e2.salary>=e1.salary ) 1) What the query returns? 2) How it works? - Detail explanation (what the sub query does, why it is (where 2=)....etc...Please?

5 Answers  

---

do views contain data ?

0 Answers   MCN Solutions,

---

How to test a dml trigger in ms sql server?

0 Answers  

---