What are the factors you will check for the performane optimization for a database query?

7 Answers   CarrizalSoft Technologies, DELL, SoftSol,

---

Name few of the dcl commands in sql?

0 Answers  

---

If i am handling 150 servers then how to check the active jobs of all the servers?

0 Answers  

---

How can change procedure in sql server?

0 Answers  

---

What are the steps need to be take improve the speed of a SQLDATA Server?

2 Answers   IBM,

---

---

In performance wise distinct is good or group by is good? eg:select name from emp group by name; select distinct name from emp;

5 Answers   Infosys,

---

What gets stored inside msdb database?

0 Answers   Abacus,

---

What is the command used to get the version of sql server?

1 Answers  

---

What happens if you are trying to access a schema not owned by you?

0 Answers  

---

Delete duplicate rows from a table without primary key by using a single query Table Employee empname salary A 200 B 300 A 200 C 400 D 500 D 500 Output should be A 200 B 300 C 400 D 500

14 Answers  

---

List out the different types of locks available in sql server?

0 Answers  

---

How do I open a .db file?

0 Answers  

---