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,

---

how can do you the system monitoring?

1 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  

---

Diffrent types of function

1 Answers   Wipro,

---

How do database indexes work?

0 Answers  

---

---

What are the advantages of using views. Why do we need views when we have SPs?

4 Answers   247Customer,

---

Why do we backup Active Directory ?

0 Answers  

---

What is a Join and explain its types?

0 Answers  

---

Detail about query optimizer?

0 Answers  

---

what is statistics

1 Answers  

---

How to select Distinct columns from the table, table having 20 columns and i want all coulmns

5 Answers   Wipro,

---

when inserting to a table how many rows will be effected using triggers

2 Answers  

---