Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag TVP Rss

   Items 1 to 6 of 6   
 

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,371 reads

Passing Tables as Parameters

By Dwain Camps 2013/03/25 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,027 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: SQLServerCentral.com | Category: tvp
Rating: |  Discuss |   Briefcase | 5,896 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: SQLServerCentral.com | Category: tvp
Rating: |  Discuss |   Briefcase | 9,501 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: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 8,304 reads

Table Variables

By Sudhir Chawla 2008/11/27 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 4,063 reads
   Items 1 to 6 of 6   
 
Tags
t-sql (4)    
sql server 2008 (2)    
.net (1)    
application programming (1)    
correlation (1)    
ienumerable (1)    
loading data (1)    
performance tuning (1)    
pivot (1)    
streaming (1)    
xml (1)