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

Published Jan 15 2019 04:53 PM 139 Views
Microsoft
First published on MSDN on Mar 08, 2016

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

%3CLINGO-SUB%20id%3D%22lingo-sub-318697%22%20slang%3D%22en-US%22%3ESQL%202016%20-%20It%20Just%20Runs%20Faster%3A%20TVPs%20with%20Spatial%20Column(s)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-318697%22%20slang%3D%22en-US%22%3E%0A%20%26lt%3Bmeta%20http-equiv%3D%22Content-Type%22%20content%3D%22text%2Fhtml%3B%20charset%3DUTF-8%22%20%2F%26gt%3B%3CSTRONG%3E%20First%20published%20on%20MSDN%20on%20Mar%2008%2C%202016%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3E%3CP%3ETable%20Valued%20Parameters%20(TVPs)%20containing%20spatial%20columns%20can%20be%20used%20as%20input%20parameter(s)%20to%20stored%20procedures.%26nbsp%3B%20SQL%20Server%202016%20improves%20the%20scalability%2C%20using%20native%20spatial%20validation(s)%2C%20increasing%20performance%20by%2015%20times%20or%20more.%3C%2FP%3E%0A%20%20%3CP%3E%3C%2FP%3E%0A%20%20%3CDIV%3E%0A%20%20%20%3CTABLE%3E%0A%20%20%20%20%3CTBODY%3E%3CTR%3E%0A%20%20%20%20%20%3CTD%3E%3CP%3E%3CSTRONG%3E%20TVP%20Before%20the%20Fix%3A%20%3C%2FSTRONG%3E%3C%2FP%3E%0A%20%20%20%20%20%3C%2FTD%3E%0A%20%20%20%20%20%3CTD%3E%3CP%3E8000%20rows%2Fsec%3C%2FP%3E%0A%20%20%20%20%20%3C%2FTD%3E%0A%20%20%20%20%3C%2FTR%3E%0A%20%20%20%20%3CTR%3E%0A%20%20%20%20%20%3CTD%3E%3CP%3E%3CSTRONG%3E%20TVP%20After%20the%20Fix%3A%20%3C%2FSTRONG%3E%3C%2FP%3E%0A%20%20%20%20%20%3C%2FTD%3E%0A%20%20%20%20%20%3CTD%3E%3CP%3E120%2C000%20rows%2Fsec%3C%2FP%3E%0A%20%20%20%20%20%3C%2FTD%3E%0A%20%20%20%20%3C%2FTR%3E%0A%20%20%20%3C%2FTBODY%3E%3C%2FTABLE%3E%0A%20%20%3C%2FDIV%3E%0A%20%20%3CP%3E%3C%2FP%3E%0A%20%20%3CP%3E%3CSTRONG%3E'It%20Just%20Runs%20Faster'%20%3C%2FSTRONG%3E%20-%20Apply%20SQL%20Server%202016%20and%20TVPs%20using%20Spatial%20columns%20at%2015x%20faster%20or%20better.%3C%2FP%3E%0A%20%20%3CP%3E%3C%2FP%3E%0A%20%20%3CP%3EBob%20Dorr%20-%20Principal%20SQL%20Server%20Escalation%20Engineer%3C%2FP%3E%0A%20%20%3CP%3EGreg%20Lapinski%20-%20Principal%20SQL%20Server%20Developer%3C%2FP%3E%0A%20%0A%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-318697%22%20slang%3D%22en-US%22%3EFirst%20published%20on%20MSDN%20on%20Mar%2008%2C%202016%20Table%20Valued%20Parameters%20(TVPs)%20containing%20spatial%20columns%20can%20be%20used%20as%20input%20parameter(s)%20to%20stored%20procedures.%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-318697%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EPerformance%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Esql%202016%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Version history
Last update:
‎Jan 15 2019 04:53 PM
Updated by: