A Bristol Geek

No trees were harmed in the creation of this blog; however, a significant number of electrons were slightly inconvenienced.


Curse those cursors

Even the best written query can run away with itself sometimes; especially if you have some form of recursion in the script. Be is a while loop or a cursor; the data does not always fit the expectations of the developer. In that case the query can run and run until you run out of resources and your server starts to stutter.