I ran two different tests on instances of SQL Server 2000 and SQL Server
2005 running on the same machine.  The first involved a simple tight loop
(while statement) of 50,000 interations in a procedure with no processing.
The second involved an insensitive cursor on a table of 50,000 rows again
with no processing in the loop.

The straight loop was about 25% faster in SQL Server 2005, but the cursor
loop took almost twice as long in 2005 as in 2000.  Has anyone experienced
anything similar to this?

Thanks in advance.

Top 100 ... Order by in views SQL 2005 problem
Stored procedure to change not nulls to nulls
To write SPs, or not to write SPs, that is the question....
Client app doesn't work now!
MCITP 077-444