What is filter index?

0 Answers  

---

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

0 Answers   HCL, Wipro,

---

Explain different types of lock modes in sql server 2000?

0 Answers  

---

Hi Can any one tell me the Good institute to learn SQL esp for Data Base Testing or SQL from scratch to the proficiency level in Hyederabad and facult also. Thankyou well in advance

6 Answers  

---

What is order of B+tree?

0 Answers   HCL,

---

Tell me when is the update_statistics command used?

0 Answers  

---

What are .mdf files?

0 Answers  

---

What is the difference between Procedure and Function

4 Answers   Accenture, Nagarro, TCS,

---

Can we add a cpu to sql server?

0 Answers  

---

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

1 Answers   HCL,

---

What is cross join in sql server joins?

0 Answers  

---

whats new about truncate in sql server 2008?

0 Answers   MedSave Healthcare, Serco,

---