Posted on Leave a comment

Using Cursors Optimally

sqlwithmanoj demonstrated cases where using optimization hints such as FAST_FORWARD, FORWARD_ONLY, READ_ONLY can result in cursors that are more performant than while loops on table variables.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.