Answer Posted / hari

Cursor : Curosr is allow row processing of the result set.
Static
Dynamic
forward-only
Key setdriven

What is the maximum size of sql server database?

959

---

What is sparse columns of sql server 2008?

1002

---

What are the dmvs? : sql server database administration

1018

---

Explain the disadvantages of cursors?

1067

---

between cast and convert which function would you prefer and why?

924

---

How to filter out duplications in the returning rows in ms sql server?

1081

---

How will you make an attribute not process? : sql server analysis services, ssas

1027

---

How to include text values in sql statements?

1000

---

How do you handle datasets larger than 50 gb?

162

---

How can I check if a view exists in a sql server database?

990

---

what is dbcc? : Sql server database administration

979

---

Can we delete data from a view?

890

---

What are the indexes in sql server?

1051

---

What is index in an assignment?

906

---

In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

1952

---