Archive for October 22nd, 2008
SQL CURSOR Performance – SQL For Programmers
October 22nd, 2008 | 
Author: Last week I showed how to use the SQL CURSOR to loop through records in a database. In that article I mentioned that you want to avoid using the CURSOR if you can because it has performance problems.
The article was posted on DZone where a self-proclaimed SQL guru picked it up and left a comment basically stating an alternate way of looping through records that would do the same thing but didn’t require the CURSOR. What he suggested was the common practice of doing something like this:
Other Related Items:
Master Lock 5401D Select Access Wall-Mounted Key Storage Box with Set-Your-Own Combination LockSecure, Reliable Key StorageTrustworthy and secure, the 5401D Key Safe offers a convenient locking solution that holds up to five house or car ... Read More >
New Balance Unisex Lightning Dry Lo-Cut 3-Pack SockNew Balance Unisex Lightning Dry Lo-Cut sock provides moisture management, a compression arch support for stability and comfort by keeping the fabric tight and comes in a 3-Pack. The medium density fabric allows for proper fit and comfort
Clif Bar Energy Bars, 2.4-Ounce Bars (Pack of 24)8 Crunchy peanut butter; 8 chocolate chip peanut butter; 8 oatmeal raisin walnut. Made with organic oats and soybeans. High in protein; no trans fats;... Read More >
Posted in 
Tags: 
