SQL 2016 - It Just Runs Faster: TVPs with Spatial Column(s)

  • Article

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.

 

TVP Before the Fix:

8000 rows/sec

TVP After the Fix:

120,000 rows/sec

 

'It Just Runs Faster' - Apply SQL Server 2016 and TVPs using Spatial columns at 15x faster or better.

 

Bob Dorr - Principal SQL Server Escalation Engineer

Greg Lapinski - Principal SQL Server Developer