Geospatial support, SQL Server 08 vs MongoDB?

Question

MongoDB has lots of street cred especially since FourSquare uses it. MS SQL Server 2008 R2 also has Geospatial support.

Which DB is easier/better for doing GPS-like search? e.g. k-nearest points around point X,Y?

Answer 1

If the only Geospatial function you need is to find k-nearest points around point X,Y then any old database will do. Just use Haversine formula, and it's been implemented in a bunch of languages.