I talk about an inefficient but common use case for DISTINCT: removing extra rows from joins.

Over a decade of posts and videos involving bad habits and best practices in SQL Server.

SQL Server has updates that fix several vulnerabilities, for all modern versions from 2014 SP3 through 2022.

In this tip, I talk about various reasons a query's performance can change over time – even when the application hasn't changed.

I talk about making a minor schema improvement to large log-type tables containing repeated strings.