1
vote
2answers
51 views

update N rows with performance considerations

I have a table with OrderSequence, the schema looks roughly like this: id Name OrderSequence I have an arrays of ids ["1", "2", "3", "4"] from application, i want to set the SequenceOrder for ...
3
votes
1answer
336 views

Optimization around static cursor use

I'm currently in-house support for a vendor-supplied application which uses static cursors to crawl through a list of data. I've leaned on the vendor as much as I can to fix their cursor use with no ...
1
vote
1answer
991 views

Inner cursor performance issues

Before I tried to avoid using cursor because of performance issues. But now I have to do some calculations to reach some goals. I have a stored procedure that has a code like this: DECLARE ...