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.

Passing Tables as Parameters

A Stock Price Correlation Matrix

Building a Stock Price Correlation Matrix Using TVPs, a CROSS JOIN and the PIVOT Function

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.

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.

Table Variables

RE: Replication Error

Sorry, ran against incorrect Database; sorted, thanks!

RE: Hiding stored procedure code

I've found the posts about open source interesting and good reading. On the whole, I like the open source business model; however, in this case, my client has a compelling reason to hide the code from the customers. My client engages other clients to perform some complex financial analysis for those other clients. They charge […]

Searching Text Fields

How do I search a particular field for a given string? For instance if I have a productDescription field, that contains a 30 word description of a particular Car for example, how would I search for the word RED or AIR CONDITIONING etc? I assumed that I could use fairly simple SQL and ASP to […]

RE: Any better Ideas that may speed this procedure up?

Try this SELECT T1.Param_ID, T1.Value, MAX(T1.[Date]) as DataDate, T2.DefaultOrder, T2.Order1, T2.Order2, T2.Order3, T3.DataType_ID AS Type FROM dbo.tblValues AS T1 INNER JOIN dbo.tblParam AS T2 ON T2.Param_ID = T1.Param_ID INNER JOIN dbo.tblSetupKey AS T3 ON T3.Key_ID = T1.Key_ID INNER JOIN dbo.tblKey AS T4 ON T4.ID2 = T1.KEY_ID AND ID1 = @ID1 AND ID2 = @ID2 AND […]