I have a real love/hate relationship with DBArtisan. On the one hand, there's nothing like it for useful features. On the other the bugs are embarassingly bad. I'm currently running...

I will consider using a cursor when I am doing something that is inherently sequential (procedural) and where data volumes are small. In that scenario, a cursor (or equivalent row-by-row...

I've read a number of "get rid of cursors" articles. None of them have addressed the issues that I have faced (and solved) with cursors. Perhaps this series will be...