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.
Monthly Archive: January 2016
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).