August 1, 2006 at 12:54 pm
How many active cursors can one have running in once instance?
August 1, 2006 at 2:32 pm
To my knowledge there is not spec. max number but storage limit is to be considered.
In general its better to use as few cursors as one can. Cursor definitely
drops performance of system.
Most of the cursor logic can be replaced by proper while loop.
Hope this helps,
Kindest Regards,
Sameer Raval [Sql Server DBA]
Geico Insurance
RavalSameer@hotmail.com
August 2, 2006 at 4:33 am
like sameer said, stay away from cursors. they might seem to run fine now, but as the amount of data in your system increases your cursors will slow down so much and you will be left having to rewrite your sprocs or answering irate customers!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply