title: How to store constantly coordinates in a DB, and then update/replace on changes?
body: <p>I want to store <strong>GPS coordinates</strong> from any device into a DB on a SQL SERVER, and check it in real time on a web, that will ask constantly for positions.</p>
  
  <p>I saw others questions and answers (on StackOverflow and Google), and everybody want to add new rows (with the coordinates) on a table, where there were already stored previous coordinates.</p>
  
  <p>In my case, I don't want to store previous coordinates, I just want to know where are they <strong>NOW</strong>, so I think it has no point to add new rows.
  Therefore, the numbers of rows will remain constant.</p>
  
  <p>Since I had two tables: <em>DEVICES(idDevice, device)</em> and <em>COORDINATES(device, long, lat)</em>, <strong>everytime</strong> a device send a new position (let's say every 1 second), it value will UPDATE the row existing with its previous value.</p>
  
  <p>My question: Is that the best way (the "continuously auto-replacement" technique) I can do that? or is there a more optimal way to update positions?</p>
  
  <p>And, like a 2nd question: that's the best way to build the tables for what I want to do?</p>