Unpivoting Multiple Sets of Columns in SQL Server using CROSS APPLY

Learn how to unpivot data or sets of data with SQL Server queries using CROSS APPLY.

Further Defining the Window Clause

T-SQL Fundamentals: Controlling Duplicates

When people start learning a new field, for example T-SQL, it’s tempting to spend very little time trying to understand the fundamentals of the field so that you can quickly get to the advanced parts.

Minimal Stats Creation

Checking the Servicves

High Deadlock Priority

The Database Transaction

Changing the PK - I

Don’t use DISTINCT as a “join-fixer”

I’ve quietly resolved performance issues by re-writing slow queries to avoid DISTINCT. Often, the DISTINCT is there only to serve as a “join-fixer,” and I can explain what that means using an example.

The Temporary Synonym