title: SQL Server 2008 on a separate machine is very slow
body: <p>We have an application which gets the data from a MS SQL database residing on a server in the headquarter over an internet connection.</p>
  
  <p>Now the problem is that the data is pretty large which makes the query to take large time to transfer the data from the head quarter to the client.</p>
  
  <p>Does SQL provide anything method to speed up queries if your application is geographically separated from the database (e.g. zipping up the data before it starts to transfer) ?</p>