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

Passing Tables as Parameters

By Dwain Camps 2013/03/25 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,029 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,902 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,513 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,340 reads

Table Variables

By Sudhir Chawla 2008/11/27 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 4,064 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)