After a question on #sqlhelp, I dug into what could be making sys.partitions slow, and how they might get the required information in a more efficient way.

While I previously promoted a way to stop storing database name in your Extended Events sessions, there's an upside to collecting it: the ability to filter. Read on for more info.

For this month's T-SQL Tuesday I talk about a few distractions I enjoy when not slinging T-SQL.

I explain a recent case where sp_prepare came in handy: trying to validate a plan guide's impact.