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 is the partitioning method?

0 Answers  

---

Tell me what is use of except clause? How it differs from not in clause?

0 Answers  

---

What is log in sql server?

0 Answers  

---

how to create a scrollable cursor with the scroll option? : Sql server database administration

0 Answers  

---

---

Explain what are the different index configurations a table can have?

0 Answers  

---

What is SCOPE_IDENTITY() in sql

4 Answers   Cap Gemini,

---

What is the difference between local table and global table

1 Answers   CarrizalSoft Technologies, Polaris,

---

How to delete duplicate rows in sql server?

0 Answers  

---

What is the name of the system variable that returns the number of rows affected by a SQL statement?

0 Answers   HCL,

---

Can we use Truncate command on a table which is referenced by FOREIGN KEY?

2 Answers   Shriram,

---

What do you mean by 'normalization'?

0 Answers   Ernst Young, Thomson Reuters,

---