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

1014

---

what is normalization? : Sql server database administration

1022

---

what is a traditional network library for sql servers? : Sql server database administration

894

---

what are defaults? Is there a column to which a default can't be bound? : Sql server database administration

1069

---

what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

958

---

what is a transaction and what are acid properties? : Sql server database administration

966

---

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

968

---

what is an extended stored procedure? : Sql server database administration

993

---

what is the different types of backups available in sql server? : Sql server database administration

883

---

when would you go for denormalization? : Sql server database administration

813

---

what are defaults? : Sql server database administration

1008

---

do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

923

---

how do you test proper tcp/ip configuration windows machine? : Sql server database administration

1001

---

but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration

922

---

what is sql server? : Sql server database administration

930

---