I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration

1105

---

how to determine the service pack currently installed on sql server? : Sql server database administration

984

---

what are the different types of replication you can set up in sql server? : Sql server database administration

1038

---

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

1122

---

what are triggers? : Sql server database administration

922

---

what are cursors? : Sql server database administration

1077

---

what's sql server? : Sql server database administration

1006

---

how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration

1078

---

what is the system function to get the current user's user id? : Sql server database administration

1041

---

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

1105

---

what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration

1035

---

what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration

997

---

what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration

961

---

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

959

---

what is database replicaion? : Sql server database administration

1210

---