In case of cursors where exactly it consumes time and how to avoid it
For example I have 3500 rows with 165 columns. I need to update all those rows . For this I have taken a SP and passed those all recs as XML parameter to that SP but it is taking around 20 mins time if i run in the query analyzer.

Suggest an Idea