title: Optimize query so it does not need a Top N sort
body: <p>I have the following query</p>
  
  <pre><code>select top 25
      tblSystem.systemName,
      tblCompany.name
  from 
      tblSystem
      join tblCompany
          on tblSystem.fkCompanyID = tblCompany.pkCompanyID
  order by
      tblSystem.systemName, 
      tblCompany.name
  </code></pre>
  
  <p>That generates the first execution plan in the picture, the 2nd is the same query without the <code>order by</code><br><br>
  <img src="https://i.stack.imgur.com/jAdIZ.png" alt="enter image description here"><br>
  Is there any way a can get rid of the <code>TOP N Sort</code> (so only a <code>TOP</code>  is needed) by indexing the tables in a particular way?</p>