Tag: <span>sql</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 Sep 6, 2020 Tagged with Azure, Performance, sql, SQL Server

There are ways to greatly improve performance and power of your SQL Server databases in Azure. …

Vedran May 26, 2020 Tagged with analytic, over, sql, visualization, windowing

Did you know that SUM() aggregate can be used together with OVER() clause? A short intro …

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 Jun 29, 2018 Tagged with problem, rowversion, skipping rows, sql, timestamp

Do you use ROWVERSION/TIMESTAMP to pull changed data? If you do, you might experience a problem …