December 2013
Intermediate to advanced
1872 pages
153h 31m
English
book
Microsoft® SQL Server 2012 Unleashed
by Ray Rankins, Paul T. Bertucci, Chris Gallelli, Alex T. Silverstein
Content preview from Microsoft® SQL Server 2012 Unleashed
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,
Start your free trial
Other SQL Server 2012 Enhancements
In addition to the spatial features mentioned previously, SQL Server 2012 also includes features and enhancements that improve performance for spatial data and operations. These include new spatial indexes, a spatial index hint, compression, improved index build time, and a new query plan for spatial queries. SQL Server 2012 also 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().
Spatial Index Improvements
A new auto grid spatial index is available for both spatial types: geometry_auto_grid and geography_auto_grid ...