SOFTMAX Function in SQL Server

Explore the mechanics of the SOFTMAX function in SQL Server. Transform scores into probabilities with this essential tool.

The Distance Metric

Can SQL Server 2025’s REGEXP_SPLIT_TO_TABLE fix STRING_SPLIT in T-SQL?

Learn how to split strings efficiently in T-SQL using STRING_SPLIT and the REGEXP_SPLIT_TO_TABLE function in SQL Server 2025.

How to Calculate Distance Between Coordinates in SQL Server

Learn a quick way to calculate distances without resorting to spatial calculations.

Creating a JSON Document III

SQL Server Table-Valued Parameter Join Issues in Stored Procedures

Learn how table valued parameter joins in SQL Server stored procedures can negatively impact query performance.

Net Present Value and Internal Rate of Return in SQL Server

Many organizations store cash-flow data inside SQL Server and decision-makers often need metrics like Net Present Value (NPV) and Internal Rate of Return (IRR) to evaluate those cash flows. Is it possible to calculate NPV and IIR values in SQL Server without the use of external tools?

Understanding Deadlock Victim Selection in SQL Server

A short introduction to how deadlocks work and how you can affect their behavior inside your system.

T-SQL Trigonometric Functions in SQL Server

Introduction SQL Server includes several built-in mathematical functions that allow developers to perform complex calculations directly within queries. Among these are trigonometric functions such as SIN(), COS(), and TAN(), which are useful in scenarios involving engineering calculations, geographic data processing, simulations, and analytics. Although these functions are straightforward to use, developers occasionally encounter unexpected results […]

T-SQL in SQL Server 2025: JSON_ARRAYAGG

Learn how the JSON_ARRAYAGG() function works in SQL Server 2025.