SQL 2016 – It Just Runs Faster: Native Spatial Implementation(s)

Moved from: bobsql.com


Spatial data is among, if not the fastest, growing storage types for the SQL Server database.   It is common place for customers to have 3,000,000 or more rows in a database.   Customers are tracking vehicles, delivery locations, drilling positions and much more, leveraging the information to efficiently run their business.


To fully appreciate the ‘native implementation‘ gains in SQL Server 2016 it is helpful to understand the architecture of SQL Server Spatial data types.


The Microsoft.SqlServer.Types (managed component) exposes the spatial objects. The managed component contains some lightweight logic and then calls the SqlServerSpatial###.dll (unmanaged component)