Performance Comparison of (SELECT TOP 1) Verses MAX()

Figure 1: Select Top query, with no index.

I recently came across a post on Stackoverflow regarding the performance of using a SELECT TOP 1 query in comparison to using the MAX() function. My initial thoughts on this were that the MAX() function would provide the best performance however, in order to be absolutely certain and prove my initial hypothesis I decided to [...]

New SQL Server Resources

    One of the joys of working with SQL Server technologies is that there are some truly great knowledge resources available for use. You just have to know where to look. With the volume of information available it can be difficult to sift out the really good stuff. I know throughout my time as [...]