TVP

Maximizing Throughput with TVPs

  • Article

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.

2013-06-21

4,644 reads

Blogs

How to: exec sp_help on temp tables?

By

Say you have a temp table and you want to see the columns names. For...

Daily Coping 26 Feb 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

ADF: Querying JSON documents

By

In my previous blog post I talked about how to read from an XML...

Read the latest Blogs

Forums

object_name (st.objectid) returns NULL. How can I overcome/fix this?

By VoldemarG

How can I overcome/fix this? object_name (st.objectid) in the code below returns NULL. (in...

List all stored procedures which return datasets

By AlexF

Is there any way to do that? I need to list that kind of...

SSRS Export to separate pdfs

By spboutput

Hi everyone, can anyone tell me the process of how to create multiple pdf's...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers