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,

---

What are the magic tables in SQL Server 2000?

7 Answers   Infogain, Merrill Lynch,

---

What are the properties of primary key?

0 Answers  

---

What is BLOCK statements in SQL?

0 Answers   HCL,

---

Explain what is lock escalation and what is its purpose?

0 Answers  

---

what is difference between having and where clause ?

3 Answers  

---

what kind of lan types do you know? : Sql server database administration

0 Answers  

---

If any stored procedure is encrypted, then can we see its definition in activity monitor?

0 Answers  

---

What does the INSTEAD OF trigger do?

3 Answers  

---

Is index a datbase objects in sql server?

2 Answers  

---

What is difference between global temporary tables and local temporary tables?

0 Answers   Tech Mahindra,

---

What is index?

1 Answers   Cap Gemini,

---