Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Articles with tag TVP Rss

Search for any content tagged tvp

   Items 1 to 4 of 4   

Maximizing Throughput with TVPs

TVPs offer several performance optimization possibilities that other bulk operations do not allow, and these operations may allow for TVP performance to exceed other bulk operations by an order of magnitude, especially for a pattern where subsets of the data are frequently updated.  Read more...
By Additional Articles 2013/06/21 | Source: SQLCAT | Category: tvp
Rating:  Rate this |   Briefcase | 4,515 reads

A Stock Price Correlation Matrix

Building a Stock Price Correlation Matrix Using TVPs, a CROSS JOIN and the PIVOT Function  Read more...
By John Ryle 2012/05/14 | Source: | Category: tvp
Rating: |  Discuss |   Briefcase | 6,005 reads

SQL Server 2008 Table Valued Parameters Performance

An article from Scott Zurolo tests the terformance of SQL Server 2008 Table Valued Parameters against more traditional methods of updating many rows at once.  Read more...
By Scott Zurolo 2010/07/08 | Source: | Category: tvp
Rating: |  Discuss |   Briefcase | 9,594 reads

Streaming Data Into SQL Server 2008 From an Application

Reduce both time and memory utilization when uploading bulk data to SQL Server 2008 by combining Table-Valued Parameters (TVPs) and the .Net IEnumerable interface.  Read more...
By Solomon Rutzky 2009/05/28 | Source: | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 8,793 reads
   Items 1 to 4 of 4