What is self join in sql server joins?

0 Answers  

---

what is Constraint? How many types of constraints in SQL ?

38 Answers   HCL, IBM, NIIT, Wipro,

---

event classes in sql server

2 Answers   Accenture, AFE,

---

Explain primary key?

0 Answers  

---

What is lock escalation and what is its purpose?

0 Answers  

---

You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?

0 Answers  

---

Using query analyzer, name 3 ways you can get an accurate count of the number of records in a table?

5 Answers   eFunds,

---

What types of integrity are enforced by a foreign-key constraint

1 Answers  

---

Will sql server 2005 allow you to reduce the size of a column?

0 Answers  

---

what is IDE,DMV in sql server?

1 Answers   Value Labs,

---

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  

---

Is it possible to create trigger on views?

0 Answers  

---