title: Sql Query Execution Time difference between SSMS & SqlCommand
body: <p>I am executing one SQL query in SQL Server Management Studio (2008) and the same query using <code>SqlCommand</code> (.net 3.5) in C#.</p>
  
  <p>In Management Studio the query executes in <strong>1.6 minutes</strong> to complete. The same query is taking <strong>9 minutes</strong> using <code>SqlCommand</code> in C#.</p>
  
  <p>Why is the huge difference between SQL Server Management Studio &amp; <code>SqlCommand</code>?</p>
  
  <p>Please somebody help me in finding the solution in fixing the time difference.</p>
  
  <p>Thanks in advance.</p>
  
  <p>The query:</p>
  
  <pre><code>SELECT * INTO [target_table]
  FROM [source_table] WHERE Group_ID IN (1,2,3,4,5,6,7,8,9,10)
  </code></pre>
  
  <p>This copies around 1 million rows into target_table &amp; table contains 220 columns.</p>