[SQL] Cursors

I have never seen cursors being well used, except for DBA work. And good DBAs, most of the time, know what they are doing. But, if you are reading this, you are not a DBA, right?

Database Administrator.

Tip, ki je ponavadi zadolžen, da gleda bazo med delovanjem in postavlja indekse, postavlja particije, spravlja redo loge in pizdi čez programerje, ko z bazo delajo narobe.

Pa seveda piše SQL skripte za vzdrževanje baze, ki uporabljajo kurzorje :)

BTW, kurzorji niso tak bavbav, se pa strinjam s tem da jih večina programerjev ne razume dobro: kurzor pomeni, da je nekje na SQL strežniku alocirano/porabljeno potencialno ogromno virov. Včasih je to smiselno in ceneje, v večini praktičnih primerov pa ne.

I have never seen cursors being well used, except for DBA work. And good DBAs, most of the time, know what they are doing. But, if you are reading this, you are not a DBA, right?

OK, to pove dovolj :)