What is extended stored procedures?

0 Answers  

---

Where do we generally create INDEX?

1 Answers   Ernst Young, Thomson Reuters,

---

What is difference between materialized view and view?

0 Answers  

---

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

0 Answers  

---

Describe in brief sql server monitoring ways.

0 Answers  

---

---

What is the optimization being performed in oracle and SQL Server?

0 Answers   Cap Gemini,

---

What are user-defined functions (udfs) in sql server?

0 Answers  

---

what is the out put of below queries? a. select * from Emp where null = null; b. select * from Emp where 1=1;

13 Answers   Patni,

---

What is normalization? Explain different forms of normalization?

0 Answers  

---

I have a table emp , Fields with empname,dnname,dno,salary. now I want copy distinct salary with all emp detail from emp into new table which is not already exist in database. how would I do this ?

2 Answers   Techno Labs,

---

What is the difference between inner join and equi join?

0 Answers  

---

What is normalization according to you and explain its different levels?

0 Answers  

---