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 the use of keyword with encryption. Create a store procedure with encryption?

0 Answers  

---

What are trace flags and mention a few common trace flags used with sql server?

0 Answers  

---

What are the steps you will take to improve performance of a poor performing query?

1 Answers   HCL,

---

explain different types of jions with examples briefly?

3 Answers   Zensar,

---

What is meant by Active-Passive and Active-Active clustering setup?

0 Answers  

---

find 2nd highest salary of person using cursor concept?

6 Answers   HCL,

---

Why use view instead of a table?

0 Answers  

---

How to create a dynamic cursor with the dynamic option?

0 Answers  

---

I have student marks in a student table. I need second highest mark .Then what will the query for this?

37 Answers   NetCore, Patni, SAP Labs, Temenos, Wipro,

---

Explain various data region available in ssrs with their use?

0 Answers  

---

Do you think BCNF is better than 2NF & 3NF? Why?

0 Answers   Ernst Young,

---