Answer Posted / vikash kumar mishra

There are five type of cursors in SQL server.
1)Base table:- This is lowest level cursor.

2)Static :- This is scrollable query cursor in earlier
versions of SQL Server Compact Edition

3)Forward-only:- The forward-only cursor is the fastest
cursor that you can update, but it does not support
scrolling.

4)Forward-only/Read-only:- Forward-only/read-only cursors,
referred to as forward-only cursors in earlier versions of
SQL Server Compact Edition, are the fastest cursors, but
cannot be updated.

5)Keyset-driven:- The keyset-driven cursor in SQL Server
Compact Edition is a scrollable cursor that you can update.
A keyset-driven cursor is controlled by a set of physical
identifiers known as the keyset.

What is application role in sql server database security? : sql server security

993

---

you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration

890

---

What is recompile sql server?

989

---

What are different types of roles provided by ssrs?

144

---

Is sql server a database?

924

---

What is table-valued sub query?

921

---

Why is sql server log file full?

976

---

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

970

---

What is multilevel indexing?

878

---

Explain a differential backup?

948

---

What are horizontal and vertical scaling?

170

---

How does stuff differ from the replace function?

957

---

Can you roll back the ddl statement in a trigger?

913

---

What are the purposes and advantages stored procedure?

889

---

Explain Geography datatype in SQL Server

1060

---