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

0 Answers  

---

What is a bit datatype?

0 Answers  

---

In which tcp/ip port does sql server run? Can it be changed?

0 Answers  

---

How can you stop stored procedures from recompiling?

0 Answers  

---

What do you mean by the term 'normalization'?

0 Answers   Tech Mahindra,

---

---

How will you find out if there are expensive SQL statements running or not?

0 Answers   Atos Origin,

---

What are system databases into sql server (2005/2008) : sql server database administration

0 Answers  

---

you are provided with the single table having say 4 col ie fname lname age city , now the all records with displying of only fname and lname is required but in this format say my name is abhay khanna it will come like this abhay-khanna rahul-roy gaurav-singh the above format is required

3 Answers  

---

What is query optimizer in sql server?

0 Answers  

---

What is the difference between indexing and hashing?

0 Answers  

---

What is BCNF? How is it better than 2NF & 3NF?

0 Answers   Essar,

---

What is difference between commit and rollback when used in transactions?

0 Answers  

---