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 5 of 5   
 

Passing Tables as Parameters

By Dwain Camps 2013/03/25 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,859 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,676 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,321 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 | 7,941 reads

Table Variables

By Sudhir Chawla 2008/11/27 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 4,045 reads
   Items 1 to 5 of 5   
 
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)