Performance of sys.partitions
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.
Monthly Archive: January 2021
Maybe you do want to collect database name in Extended Events
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.
Patch Tuesday 2021-01-12 : SQL Server Updates
A security fix for an elevation of privilege issue has been released for all supported versions of SQL Server.
T-SQL Tuesday #134 : Give Me a Break!
For this month's T-SQL Tuesday I talk about a few distractions I enjoy when not slinging T-SQL.
A use case for sp_prepare / sp_prepexec
I explain a recent case where sp_prepare came in handy: trying to validate a plan guide's impact.