TVPs With Spatial Columns

The CSS SQL Server Engineers note that TVPs with spatial columns are now much faster than before:

Table Valued Parameters (TVPs) containing spatial columns can be used as input parameter(s) to stored procedures.  SQL Server 2016 improves the scalability, using native spatial validation(s), increasing performance by 15 times or more.

This is a pretty out-there edge case in my experience, but maybe there’s a niche.

Related Posts

SQL Server And Polygons

Bert Wagner shows that SQL Server interprets polygon definitions a bit differently from GeoJSON: Discerning eyes might notice that SQL Server didn’t shade in the area inside of the polygon — it instead shaded in everything in the world EXCEPT for the interior of our polygon. If this is the first time you’ve encountered this behavior then […]

Read More

Spheres In SQL Server

Slava Murygin continues his quest to build a graphics engine with spatial data: Couple of years ago I came up with an algorithm of drawing an ellipse using SQL Server spatial geometry: I’ve used that algorithm to make a sphere and as in my previous blog of drawing 3D Cube I use external procedure to simplify the […]

Read More


March 2016
« Feb Apr »