Mention the differences between having and where clause.

1082

---

Explain the usage of floor function in sql server.

979

---

What do you understand by replication in sql server?

1080

---

What do you understand by hotfixes and patches in sql server?

1003

---

Mention the different authentication modes in sql server.

1073

---

Mention the 3 ways to get a count of the number of records in a table.

999

---

Mention a few common trace flags used with sql server?

947

---

What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?

984

---

What do you understand by coalesce in sql server?

1087

---

What do you understand by mirroring and mention the advantages of the mirroring?

1077

---

Mention the differences between local and global temporary tables.

1056

---

What do you understand by check constraint in sql server?

960

---

What is the tcp/ip port on which sql server runs?

1175

---

What do you understand by intent locks?

1024

---

Explain log shipping and mention its advantages.

1056

---