Answer / manoj pandey

- SELECT is a Query operator, which is also called a set-based approach.

- CURSOR is a looping operator, which is also called a iterative approach or no-set based approach.

Ideally SELECT is more performant than CUSROSR, but there are certain scenarios when CURSOR are the last approach and sometimes beneficial.

More about Cursors:
- Cursor Life Cycle: http://sqlwithmanoj.wordpress.com/2010/10/24/sql-server-cursor-life-cycle/
- Cursor Performance: http://sqlwithmanoj.wordpress.com/2011/02/07/avoid-cursors-or-use-them-optimally/

Check my blog for more Interview Questions: http://sqlwithmanoj.wordpress.com/interview-questions/

Scalability, Availability, Integration with internet, etc.)?

0 Answers  

---

What do you understand by replication in sql server? Mention the different types of replication in sql server.

0 Answers  

---

What is table valued function and scalar valued functions?

0 Answers  

---

What is triggers and its types?

0 Answers  

---

If a table does not have a unique index, can a cursor be opened on it?

0 Answers  

---

How to apply cascading referential integrity in place of triggers?

0 Answers  

---

What do you mean by cardinality?

0 Answers  

---

what are isolation levels? : Sql server database administration

0 Answers  

---

Explain user defined views?

0 Answers  

---

What is the difference between drop table and truncate table?

0 Answers  

---

what is Full Text Search ?

1 Answers   TCS,

---

How will you fine tune a stored procedure or what are the steps that should be taken to fine tune or optimize a stored procedure?

1 Answers   Logitech, Mphasis,

---