title: Azure SQL "select" query not showing all rows
body: <p>I just used the SQLAzureMW (SQL Azure Migration Wizard Tool) to migrate my SQL Server database to Azure SQL. It went off without a hitch - all my tables are there, the website is running fine off it, etc. </p>
  
  <p>Here's what's odd: if I execute a simple <code>SELECT</code> statement against my tables, I get only a few of the rows. I assumed they were missing, but my website is using some of those records as if they're there. So I queried with a <code>WHERE</code> clause and BAM - they showed up. How the... what the... why isn't my select showing me everything? This applies to many of the tables I've tested.</p>
  
  <h2>SQL Azure</h2>
  
  <p><img src="https://i.stack.imgur.com/DaviD.png" alt="enter image description here"></p>
  
  <h2>On-Premise</h2>
  
  <p><img src="https://i.stack.imgur.com/t1tT5.png" alt="enter image description here"></p>