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.


4,644 reads


Adding a License to GitHub


I’ve rarely thought about licensing my code, but it’s something to be aware of...

Weekly reading #29


The Data Breach Game: The 9 Worst IT Security Practices Joey D’Antoni shows bad...

#PowershellBasics: Get-Help -Online


One of the other things I learned from the Powershell class I’m taking this...

Read the latest Blogs


2019 Jordan Spizike Court Purple Coming Soon

By stevenrowe98

made its debut earlier in the year that was constructed using recycled foam from...

Introduction to the Partition By Window Function

By Additional Articles

Comments posted to this topic are about the item Introduction to the Partition By...

Do What Hurts

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Do What Hurts

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers