My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Spatial indexes in SQL Server
The new RSS feed is here
Someone asked a question recently about the spatial capabilities of SQL Server. Whilst there is nothing provided out of the box the use of CLR in SQL Server 2005 provides numerous possibilities.
Have a read of the following article if this is of interest http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/TblValFuncSQL.asp
... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Spatial indexes in SQL Server