In which tcp/ip port does sql server run? Can it be changed?

996

---

What is "scheduled jobs" or "scheduled tasks"?

983

---

What is the dbcc command and why is it used?

1056

---

How will you decide the active and passive nodes?

1135

---

How can you hide the sql server instances?

1024

---

What is the difference between value type and reference type?

926

---

Define magic tables in sql server?

1070

---

Explain different types of collation sensitivity?

987

---

What command is used to rename the database?

1018

---

What is the sql server agent?

1096

---

What is sub-query in sql server? Explain its properties.

1097

---

What is the most common trace flags used with sql server?

1052

---

Explain the properties of sub-query in sql server?

1022

---

What are the different types of collation sensitivity in sql server?

1113

---

What are the advantages of using third-party tools?

998

---