Query Store and Automated Cleanup

Query Store has mechanisms for automatically cleaning your data. It is possible to cause them to break down. While presenting...

Every Single Execution Plan is an Estimated Plan

All the execution plans are estimated plans. All of them. There fundamentally isn’t any such thing as an “Actual” plan.

Where...

Execution Plans and the GDPR

What? Execution plans and the GDPR? Is this it? Have I completely lost it? Well, no, not on this topic,...

Precons in Richmond, Philadelphia and New York

I love when I get the opportunity to present at SQLSaturday events. Even more than that, I love when I...

YouTube Channel Update

Hey! Here’s the latest on my YouTube Channel. Click on through and subscribe. I’ll be doing lots of stuff on...

Adaptive Joins

I was surprised to find out that a lot people hadn’t heard about the new join type, Adaptive join. So,...

GDPR: Your Hair Is Not On Fire

Along with a lot of other people, I’ve been attempting to call people’s attentions to the new General Data Protection...

Building Culture

The origins of PASS have shaped its culture for years. Are you doing the same in your organization?

Wait Statistics on a Query

Wait statistics are a vital part of understanding what is causing your system to run slowly. Capturing them can be...

Database Fundamentals #16: Removing Data With T-SQL

Deleting data from a table using T-SQL works quite a lot like the UPDATE statement.

How it Works
In the same way...