Monday, February 28, 2022

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

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.

Posted at https://sl.advdat.com/3vqdD1Khttps://sl.advdat.com/3vqdD1K