The support of SQL CLR allows applications to manage rich user-defined data such as mathematical or geographical based data. SQL Server 2008 enables the native support of .NET CLR data types by providing two data types: GEOMETRY and GEOGRAPHY.
Managing a spatial type of data will require high-performance and high-end hardware with a massive data storage solution. However, SQL Server features on these two new data types have enabled the applications to support various methods that will allow for creation, comparison, analysis, and spatial data retrieval. In this recipe, we will go through the process of designing spatial data storage methods using SQL Server 2008 R2.
Note
For more on OGC and the WKT/WKB/GML XML transport formats, review http://www.opengeospatial.org/standards/sfa.