Browse by Tags

A couple of years ago, John Sansom wrote a blog post comparing the performance of two different ways to get the maximum value from a column: MAX() and TOP (1).
http://www.johnsansom.com/performance-comparison-of-select-top-1-verses-max/
In the conclusion, he states:
When a clustered index is present on the table & ...