title: What is the fastest way to select a single row in SQL? (SQL Server)
body: <p>I know of two different ways to select a single row from a table (without a where clause that guarantees a single record).</p>
  
  <pre><code>SELECT TOP 1 [Id]
  FROM [MyTable]
  ORDER BY [Id] ASC
  </code></pre>
  
  <p>or</p>
  
  <pre><code>SELECT [Id]
  FROM [MyTable]
  ORDER BY [Id] ASC
  OFFSET 0 ROWS
  FETCH NEXT 1 ROWS ONLY
  </code></pre>
  
  <p>Which of these is statistically faster? (<code>[Id]</code> is a primary key)</p>
  
  <p>Or is there a faster alternative to both of these that I'm unaware of?</p>