How to drop existing indexes in ms sql server?

0 Answers  

---

Is the log file is a part of file group?

0 Answers  

---

How many clustered indexes there can be on table ?

0 Answers  

---

What are the different types of backups that exist?

0 Answers   ADITI,

---

1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.

0 Answers   Aptroid,

---

how would you improve etl (extract, transform, load) throughput?

0 Answers   LinkedIn,

---

Explain sub-query?

0 Answers  

---

Difference between aggregate functions of sql?

0 Answers   EXL,

---

Explain what are commit and rollback in sql?

0 Answers  

---

Do you know what are the restrictions applicable while creating views? : SQL Server Architecture

0 Answers  

---

I have a table EMP in which the values will be like this EmpId Ename Sal DeptId 11 Ram 10000 10 11 Ram 10000 10 22 Raj 20000 20 22 Raj 20000 20 33 Anil 15000 30 33 Anil 15000 30 I want to delete only duplicate Rows. After Delete I want the output like this EmpId Ename Sal DeptId 11 Ram 10000 10 22 Raj 20000 20 33 Anil 15000 30

13 Answers   DELL,

---

What are different types of replication in sql server?

0 Answers  

---