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.
Published Feb 28, 2022
Version 1.0
BobDorr
Microsoft
Microsoft