Code Blocks

Crazy Code I

STRING_AGG's behavior

Converting Old Running Total Code to Window Functions

This article looks at the old style of calculating a running total and how to convert that to code that uses a window function.

Disabling Indexes

Effective Strategies for Storing and Parsing JSON in SQL Server

Like XML, JSON is an open standard storage format for data, metadata, parameters, or other unstructured or semi-structured data. Because of its heavy usage in applications today, it inevitably will make its way into databases where it will need to be stored, compressed, modified, searched, and retrieved.

SQL ROUND Function vs. Bankers Rounding with T-SQL

Learn about rounding values using T-SQL and how the ROUND function works compared to creating a user-defined function for bankers rounding.

CONCAT NULLs

Converting Integers

Days of the Week, Bitwise Edition

I recently had to help support synchronization and distribution of workloads between multiple servers.