Locating most current record using ROW_NUMBER() vs. Index Full Scan (Min/Max) December 1, 2017 Very often when reading data, we need to locate the most current record for a set of conditions....