Controversial running total calculations in SQL Server using the "Quirky Update"

SQL snips for querying sysobjects table and using the results to dynamically generate SQL query

SQL snips for querying and enabling temporal tables

This is a collection of SQL snippets for tracking down what is running and what might be misbehaving

DELETE large amounts of data from a huge database table with this one simple trick

Today I embark on a new journey of writing down my thoughts and experiences in software development