Why cursor is a bad idea?

Cursor is a bad idea, since it lock a table used to populate a cursor while you loop through the cursor and do  some operation on fetched records.

Here is some article about it http://www.sqlbook.com/SQL/Avoiding-using-SQL-Cursors-20.aspx