Microsoft® SQL Server 2012 Unleashed
by Ray Rankins, Paul T. Bertucci, Chris Gallelli, Alex T. Silverstein
Spatial Data Enhancements
SQL Server 2012 adds four new spatial type classes: FULLGLOBE, CIRCULARSTRING, COMPOUNDCURVE, and CURVEPOLYGON. SQL Server 2012 also includes features and enhancements that improve performance for spatial data and operations, including new spatial indexes, a spatial index hint, compression, improved index build time, and a new query plan for spatial queries. In addition, SQL Server 2012 provides further performance enhancements at the spatial library level for Distance() and ShortestLineTo() methods along with performance improvements at the SQL level for methods which are based on them, including STDistance() and ShortestLineTo().
For more information on the enhancements to spatial data and working with spatial data ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access