what are isolation levels? : Sql server database administration

983

---

what is normalization? Explain different levels of normalization? : Sql server database administration

1308

---

what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration

1125

---

what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

1025

---

what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

918

---

what are user defined datatypes and when you should go for them? : Sql server database administration

1006

---

what are constraints? : Sql server database administration

1051

---

what is the difference between delete table and truncate table commands? : Sql server database administration

1031

---

what is the information that can be stored inside a bit column? : Sql server database administration

955

---

how to avoid cursors? : Sql server database administration

967

---

what is the maximum size of a row? : Sql server database administration

1005

---

what are the disadvantages of cursors? : Sql server database administration

1027

---

what is a transaction? : Sql server database administration

990

---

what are candidate key, alternate key and composite key? : Sql server database administration

913

---

what is a self join? : Sql server database administration

1030

---