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

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: http://slavasql.blogspot.com/2015/02/drawing-ellipse-in-ssms.html 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

Drawing Cubes With SQL Server Spatial

Slava Murygin has entered his cubism phase: Hey, there is a time to go level up and instead of drawing Spirals, Fractals and other cool stuff I decided to go 3D! So, the first my try will be drawing 3D cubes. As you know, SQL is not an Object Orienting Programming language, and I can’t […]

Read More

Categories

March 2016
MTWTFSS
« Feb Apr »
 123456
78910111213
14151617181920
21222324252627
28293031