What is subquery in sql?

0 Answers  

---

What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?

0 Answers  

---

What is index fragmentation in ms sql server?

0 Answers  

---

could you please reply for these question: 1.About Use Apply? 2.Avoid cursors - When we have a situation that we can not avoid the use of cursor than what is the alternate solution? is there anything we can use instead of cursor to perform the desired task? which optiomize the peroformance too. 3.What is computed columns? Thanks in advance. Regards, Rupesh

3 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 an indexing strategy?

0 Answers  

---

What are joins in sql and what are the different types of joins?

0 Answers  

---

can primery key be a non clustered index?

10 Answers  

---

Explain the benefits of user-defined functions?

0 Answers  

---

What do you mean by COLLATION?

4 Answers   ABC, BirlaSoft,

---

i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.

0 Answers  

---

How to join two tables in a single query in ms sql server?

0 Answers  

---