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

Published Feb 28 2022 07:21 AM 412 Views
Microsoft
Moved from: bobsql.com

 

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.

Co-Authors
Version history
Last update:
‎Feb 28 2022 07:21 AM
Updated by: