ms sql geometry: intersection of multiple polygons
===

I have multiple polygons in one table (TableColumnName-dataType: ImageId-int, Quality-float, Border-geometry ) how can i find all intersects of polygons using ms sql functions with more hight performance. Is there are any function which help to find intersections without iteration and without comparison each polygon with each Or any sample how to do it. Can anyone help me?