Do you know what is normalization of database? What are its benefits?

1122

---

Explain go command in sql server?

1032

---

What is sql stored procedure?

1093

---

What is blocking?

1064

---

Do you know query execution plan?

1172

---

Do you know what is sql service broker?

1086

---

Explain what is the function of sql server agent windows service?

994

---

Explain what are various ways to enhance the ssrs report?

1044

---

What is a linked server in sql server?

1075

---

Do you know what is a trace frag? Where do we use it?

997

---

Explain what are sparse columns?

992

---

Explain differentiate between a having clause and a where clause?

912

---

Tell me what do you mean by an execution plan? Why is it used? How would you view it?

883

---

How many levels of sp nesting is possible?

1054

---

Tell me what is de-normalization and what are some of the examples of it?

1043

---