Another excellent post from Roger Doherty !
In our last series of posts Zach and I talked about using SQL Server's new FILESTREAM support to store, manage and retrieve media in SQL Server to enable rich user experiences. We've been at it again this week trying to get some traction with the new spatial data types and query semantics in SQL Server 2008. This new functionality makes it possible to integrate location awareness into just about any type of application. What could be more compelling than allowing a user to interact with information that is relevant to locations that they care about, like home, work, school or vacation destinations? This technology has long been the domain of sophisticated GIS applications, but by integrating spatial capabilities into SQL Server 2008, Microsoft is making location awareness available to the average database developer
Following is here : http://blogs.msdn.com/rdoherty/archive/2007/10/28/demystifying-spatial-support-in-sql-server-2008.aspx