title: SQL Server 2008+ : Best method for detecting if two polygons overlap?
body: <p>We have an application that has a database full of polygons (currently stored as points) that a .net app pulls out and checks if they overlap.</p>
  
  <p>I occurred to me that it would be much nicer to convert these point arrays to polygon / polyline objects within the database and use sql to get a bool of weather they overlap or not.</p>
  
  <p>I have seen different methods suggested to do this but non of the examples given were quite in-line with my needs.</p>
  
  <p>I would be very happy to receive input from those kind enough to offer their experience.</p>
  
  <p>Additional:</p>
  
  <p>In response to questions: It is indeed 2D. and yes any crossover of the two is considered true. The polygons have n points and can be concave. The polygons will be saved as 1 per row (after data conversion task) as polygons (i.e. the polygon type .. it might be called something else spatial / geom my memory is not on my side right now)</p>