Answer Posted / talha

1 yes
2 no
3 no
4 no
5 no
6 no

What is difference between cte and view?

858

---

how to do partition in sqlserver

2413

---

Explain syntax for viewing trigger?

888

---

Why I am getting "the microsoft .net framework 2.0 in not installed" message?

916

---

List few advantages of stored procedure.

928

---

What is 1nf normalization form?

981

---

What is pivot and unpivot?

978

---

How many types of dimensions are there and what are they? : sql server analysis services, ssas

1029

---

How many non clustered indexes there can be on table ?

863

---

What is always encrypted?

942

---

How to provide default values to function parameters?

1054

---

A trigger can reference objects outside the current database? State true or false.

948

---

Which are the third-party tools used in sql server and why would you use them?

844

---

What are scheduled tasks in sql server?

1011

---

What is user-defined inline table-valued function?

900

---