Answer Posted / ravi

select top 2 from tablename

What is difference in performance between insert top (n) into table and using top with insert?

1035

---

What is an indexing technique?

925

---

What is the boxing and unboxing concept in .net?

910

---

What is the difference between clustered and a non-clustered index?

1016

---

How to defragment indexes with alter index ... Reorganize?

1075

---

What are the tables in sql?

1081

---

How to include date and time values in sql statements?

1079

---

What is table value parameters (tvp)?

1092

---

What are the different types of cursor?

1087

---

How to create a stored procedure with a statement block in ms sql server?

1063

---

What are partitioned views?

979

---

What is the recursive stored procedure in sql server?

1017

---

What are the types of processing and explain each? : sql server analysis services, ssas

1144

---

Difference between uniqe index and uniqe constraint?

966

---

Explain about analysis services?

1043

---