As part of a new series, I take a look at what happens to the structure of a page when an INT column needs to be upsized to a BIGINT.

I compare the performance of different UDFs and raw queries used for splitting and reassembling a delimited string.

I discuss a few counterpoints to a very thorough and useful post on database naming standards.

I revisit an older post about SQL Server pagination to see if any implementation of ColumnStore indexes can improve performance.

Tip : Removing Duplicates from Strings in SQL Server

Tip : Advanced JSON Techniques in SQL Server 2016 – Part 3

A hefty introduction to common table expressions (CTEs).