Press "Enter" to skip to content

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.