为什么在SQL Server中使用游标被认为是不好的做法?

I knew of some performance reasons back in the SQL 7 days, but do the same issues still exist in SQL Server 2005? If I have a resultset in a stored procedure that I want to act upon individually, are cursors still a bad choice? If so, why?I knew of some performance reasons back in the