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.
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.
A security fix for an elevation of privilege issue has been released for all supported versions of SQL Server.
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.