Tag: <span>TSQL</span>

How to pass arrays to SQL? TVP – The Ultimate Guide

Vedran Dec 8, 2020 Tagged with arrays, batches, csharp, sql, SQL Server, table-valued parameters, TSQL, tvp

You always wanted to know how to pass arrays to SQL Server? Watch this Ultimate Guide …

Vedran May 10, 2019 Tagged with addin, addon, sp_xdetails, sql, SQL Server, sqlxdetails, TSQL, xdetails

While ago I wrote SSMS Addin called SQL XDetails. It was not updated long time because …

Vedran Nov 26, 2017 Tagged with deadlock, TSQL

Introduction Demonstration of the smallest possible deadlock: only one statement, one table, one row. Without transactions …

Vedran May 30, 2017 Tagged with Catch all query, Optimize, Performance, SQL Server, TSQL

In almost every database we have a process that filters the same data with different filters.…