SQL Server Forums - Moving away from a cursor to while loop
1. I agree, set-processing is light years ahead of row-by-row-processing 2. But if you must revert to 1960's style, then a while loop is more efficient than a cursor. Try it for yourself on a few thousand rows in production; they use different locks and m...