title: SQL Azure slow performance
body: <p>While transforming some data to SQL Azure, I have noted an unexpected behavior.
  I did a quick test and this is the result:</p>
  
  <p>I have a single table in the DB with 1M records and the DB size is 230MB, this without the non-clustered index.</p>
  
  <p>I did a simple test by creating a new table with the same schema and just copied the data from one table to another like this:</p>
  
  <pre><code>INSERT INTO [dbo].[lete_new]
             ([str_en]
             ,[str_en_fp])
  SELECT [str_en] ,[str_en_fp] FROM [dbo].[lete]
  </code></pre>
  
  <p>First of all, on me local workstation  (SELECT [str_en] ,[str_en_fp] FROM [dbo].[lete]) takes 8 seconds, so on-top of that is the time that it takes to do the insert.
  When I ran the insert on my local WS, it took 10 seconds to copy the data to the new table. The big surprise was when I ran the same query on Azure, it took 30 seconds.</p>
  
  <p>I know that this is not exactly a programming question, but still this will impact the program performance an I want to know why is the performance drop? </p>