SQL Server 2008 supports a set of methods for the geography spatial data type, including methods on geography that are defined by the Open Geospatial Consortium (OGC) standard and a set of Microsoft extensions to that standard.
OGC Methods on Geography Instances
Extended Methods on Geography Instances
OGC Static Geography Methods
Extended Static Geography Methods
Other Resources
Types of Spatial Data
Help and Information
Getting SQL Server 2008 Assistance