title: SQL Remote query very slow after migrating sql server
body: <p>I have a Sql Server 2005 express edition with one Database. I have too a C# winforms application to access to table customers that has 500 rows aprox. I have the sql server 2005 Express  inside the local pc with the winforms app. </p>
  
  <p>Now I've bought a server with SQL Server 2008 standard edition and I've migrated my database to that server and reconfigured my application to access to the new server throught Lan.</p>
  
  <p>The problem is that a simple query like <code>SELECT name, lastname,phone,fax,address FROM Customer ORDER BY name</code> (I have 500 rows) If I execute it in the server, it runs in 1 second but if I open my application (in other pc trought lan, not in the server)  it takes about 4 minutes to return the results.</p>
  
  <p>I don't know what to do because the database is very very small.</p>
  
  <p>Thanks</p>