O'Reilly logo

Microsoft SQL Server 2012 Internals by Bob Beauchemin Kalen Delaney Conor Cunningham, Jonathan Kehayias, Benjamin Nevarez, and Paul S. Randal

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Spatial indexes

Spatial data was introduced in SQL Server 2008, and SQL Server 2012 dramatically expands support for it. Spatial data is multidimensional and is meant to represent objects (also called spatial features) in multidimensional space. SQL Server supports two different spatial data types: GEOMETRY (Euclidean geometry) and GEOGRAPHY (spherical geometry). The GEOMETRY data type is also used when dealing with projected coordinate systems—that is, a coordinate system derived from projecting a portion of the earth on to a flat grid. These types are implemented natively in SQL Server as .NET classes. Spatial operations on these data types are implemented as methods or properties of the type. SQL Server supports spatial indexes over either ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required