从地理专栏中搜索附近的点

I have a geography typed column in my table with spatial index. How can I select the top N rows that is within X meters of a given Latitude/Longitude while making use of the index to improve performance?I have a geography typed column in my table wit