The memory toll of VARCHAR(MAX) in SQL Server

Introduction When designing the tables or writing the stored procedures in SQL Server, we get easily tempted to choose the path of least resistance. When deciding how much space to allocate for a text column in a database table which may contain the description of a product, a product name, or an additional comment/remarks, it […]

BIT_COUNT() V

OUTER APPLY Fundamentals: Part 2

In Part 2 of this series we learn how OUTER APPLY can be used in your queries to return data, even when there are no matches between tables.

The Range of Customers

Escaping Strings

BIT_COUNT in SQL Server

Learn how the BIT_COUNT() function works and how it enabled operations where data is stored in bits.

T-SQL in SQL Server 2025: REGEXP_LIKE

This article goes into one of the new regular expression functions in SQL Server 2025: REGEXP_LIKE().

Advanced T-SQL: Replacing Slow Cursors with Window Functions

This article looks at replacing a cursor with a window function to improve performance.

BIT_COUNT() IV

Time Series Data Mining Example with T-SQL when Adding New Data

Please demonstrate the steps for updating an existing time series dataset used in a prior data mining project with a fresh batch of data. Then, repeat the mining performed for the original dataset with the freshly updated dataset.