Answer Posted / tosh

constraint is a mechanism applied on a column to restrict the user not to enter null values,duplicate and invalid data.

Can I use sql azure as a backup with log shipping or database mirroring?

156

---

Can sql servers link to other servers like oracle?

895

---

Tell me what is the stuff and how does it differ from the replace function?

1035

---

Difference between Inner vs outer joins?

988

---

What are the basic functions for master, msdb, model, tempdb databases?

1096

---

What is b tree index?

967

---

Does sql server 2000 clustering support load balancing?

1026

---

What is sql service broker?

1026

---

What do you mean by 'normalization'?

1123

---

What is the difference between update lock and exclusive lock?

1028

---

mention different types of relationships in the dbms?

1090

---

When would you use sql joins?

1029

---

Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security

1112

---

What do you understand by the data quality services in sql server?

982

---

What is acid db?

933

---