SQL Server 2008 Geospatial Queries

Question

SQL Server 2008 has new geodata types. I am interested, however, that if I have a table with geocoded addresses, can I write a query to display all the records at a certain distance. For example, many websites have the ability to search for objects at a specific distance, such as 50 miles, and would like SQL 2008 to provide this out of the box.

Answer 1

This is exactly the kind of query that is supported by the spatial index . This blog entry provides a brief introduction that includes this type of request.