THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » testing » Plan Explorer   (RSS)
  • Why generalizations are dangerous

    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 & ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on September 15, 2011
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement