what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

960

---

what are acid properties? : Sql server database administration

1015

---

how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration

922

---

explain how to create a new schema in a database? : Sql server database administration

1122

---

there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration

939

---

what is the difference between a primary key and a unique key? : Sql server database administration

1019

---

what are isolation levels? : Sql server database administration

1010

---

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

1347

---

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

1149

---

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

1046

---

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

938

---

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

1032

---

what are constraints? : Sql server database administration

1072

---

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

1056

---

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

977

---