In what circumstances are there no other option than to use cursors?

Question

In what circumstances are there no other option than to use cursors?

Viewing 2 posts - 31 through 31 (of 31 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004406 More actions · Answer 1

Heh... on something that large, I just drop the partition that has gone past the age limit. If I don't have the Enterprise edition, then I drop the "sub-table" I made and rebuild the partitioned view.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Johan Bijnens SSC Guru Points: 135375 More actions · Answer 2

I'm not going into details on this one. It's been couvered totally already.

RBarry, it is ok to refer to your series of article on how to lose the cursors and just add the remark: If you cannot use these techniques to avoid them, I guess you would be allowed to use them.

The start of this wonderful series can be found at SSC at: http://www.sqlservercentral.com/articles/T-SQL/66097/

Unless I don't know, the inverse of positive is negative

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me