title: SQL SERVER Spatial Data
body: <p>I am struggling finding an efficient way to find a distance between a Point that intersects a polygon and the border of that polygon. I was able to use the STDistance comparing the point to every point that made up the polygon but that is taking a lot of time. Using SPatial indexed wasn't much helpful because the STDistance is not part of any constraint and even when I did put the constraint, the index didn't help much.</p>
  
  <p>I appreciate any feedback.</p>
  
  <p>Thanks.</p>