Answer / ramya gurrala

Cursor is a pointer(in c/java).Cursor work with DML and information can be accessed.

Cursor is required to process each row individually for queries which return multiple rows.

Advantages:1)We can do operations on each row.
2)Response time is good.
3)Cursors are faster than the while loop.

Disadvantages:1)Repeated network round trips.
2)Occupies more resources and temporary storage.

what is the different types of backups available in sql server? : Sql server database administration

0 Answers  

---

What sql server means?

0 Answers  

---

What is the difference between seek predicate and predicate?

0 Answers  

---

Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security

0 Answers  

---

How you can minimize the deadlock situation?

0 Answers  

---

---

How to link tables in sql server?

0 Answers  

---

How do you persist objects, permissions in tempdb

1 Answers  

---

What is the difference between WHERE AND IN? OR 1. SELECT * FROM EMPLOYEE WHERE EMPID=123 2. SELECT * FROM EMPLOYEE WHERE EMPID IN (123) WHAT IS THE DIFFERENCE?

15 Answers   Adsys, Cap Gemini,

---

As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?

0 Answers  

---

What is a covering index?

0 Answers  

---

What is plan freezing?

0 Answers  

---

Is it possible to replicate data from sql server to oracle? : sql server replication

0 Answers  

---