What is difference between process and thread? Explain lazy writer funcationality.

2 Answers   Microsoft,

---

how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?

0 Answers   Facebook,

---

what is performance tunning in sql server ? explain.

1 Answers   Thomson Reuters,

---

Can you change the data type of a column in a table after the table has been created? If so, which command would you use?

0 Answers  

---

Write a SQL query to make a column as unique?

0 Answers   Cap Gemini,

---

---

wat new abt truncate in sql server

2 Answers   HCL, HP,

---

What is the basic functions for master, msdb, tempdb databases?

2 Answers   CSC,

---

Is natural join and equi join same?

0 Answers  

---

Explain sql delete command?

0 Answers  

---

What are the ways available in sql server to execute sql statements?

0 Answers  

---

How to set database to be read_only in ms sql server?

0 Answers  

---

Comment,Datatypes are unlimited

0 Answers   IBM,

---