SQL Server Performance Forum – Threads Archive

Using temp table in place of cursor to loop

What is the real difference in performance between using a cursor and using a temp table to process records individually? Will there be a noticeable difference in performance between cursors or the use a temporary table? Most articales recommend using a temp table instead of cursor to loop through records. However, it appears to me that they are similar and would not provide a benefit. Unless the nature of a cursor intrinsically has more overhead? -Thx in advance

---

check this
http://www.sqlservercentral.com/columnists/dasanka/temptablesinsqlserver.asp

---

Let’s finish the thread here:http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=9087 —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)

---

]]>