title: SQL Server - Predicate and Seek Predicate on the same column
body: <p>My table has an non-clustered index: <code>IX_columnA_columnB</code></p>
  
  <pre><code>CREATE INDEX IX_columnA_columnB ON table (columnA, columnB)
      INCLUDE (xxx)
  </code></pre>
  
  <p>My query has filter on both <code>columnA</code> and <code>columnB</code>
  On execution plan, the optimizer use <code>seek predicate</code> on both them, but I see <code>columnB</code> appears again in <code>predicate</code>
  I don't know this case. Anybody can help? Thanks so much</p>