Explain log shipping?

1033

---

What do you understand by the analysis services in sql server?

960

---

What are the steps you must follow to hide sql server instances?

993

---

What are the advantages of mirroring?

1006

---

What do you understand by user-defined function in the sql server?

968

---

What are the differences between having and where clause.

980

---

What are the options which must be set to allow the usage of optimistic models?

989

---

Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

1010

---

Mention the command used to rename the database.

1024

---

Mention the differences between sql server and mysql.

1034

---

What are trace flags and mention a few common trace flags used with sql server?

1103

---

What are subqueries in sql server? Explain its properties.

1032

---

What do you understand by mirroring?

1009

---

What are joins in sql and what are the different types of joins?

1031

---

How can you check the version of sql server?

1109

---