10Jun 2025 by Grant Fritchey 2 Comments | Grant Fritchey
Joe Fleming wants to know how I solve weird problems. I’m not sure I’m actually qualified to answer this question since I, myself, am a weird problem, but I’ll give it a shot. One aspect of my job is to provide support to our clients. No, I’m not on call (thank the gods), but I’ll […] The post T-SQL Tuesday #187: It’s Extended Events. It’s Always Extended Events appeared first on Grant Fritchey.| Grant Fritchey
I have a proper blog post coming out tomorrow for T-SQL Tuesday, but today, celebrate with me that SSMS 21 finally, at long last, fixes the irritating fact that the New Session window in SSMS for Extended Events always opened to the wrong size. Here’s SSMS 20: At the bottom of the screen on the […] The post SSMS 21 Fixes Irritating Problem appeared first on Grant Fritchey.| Grant Fritchey
I’m working on an update to my Query Performance Tuning book for SQL Server 2025 and I found myself wondering, will a query hint be immediately apparent in an execution plan without runtime metrics (AKA, Estimated Plan)? My assumption was a resounding yes, but you have to check. Query Hint in Estimated Plan I’ve got […] The post Query Hints and Estimated Plans appeared first on Grant Fritchey.| Grant Fritchey
Just a quick one this morning. I’m on the road and haven’t worked up a full blog post, apologies. I’ve been using the preview for SQL Server Management Studio 21 for a little over a week now. You should check it out. It’s been mostly stable (I got a crash. I didn’t report it because […] The post SSMS 21 appeared first on Grant Fritchey.| Grant Fritchey
Yeah, yeah, second AI post in a row. I promise not to make a habit of it. But I saw someone else mention that you can feed them XML and the AI will read the execution plan. I had to test it out and then overshare my results with all of you. We Need A […]| Grant Fritchey
A while back I wrote about using AI to explore why people are not using Extended Events. You can read all about it here, but a short summary of the biggest blockers would be: For this blog post I want to focus on the last one, Event Overload. There really are a lot of events […]| Grant Fritchey
Answering the question "Can You Tell Why a Plan Didn't Go Parallel" within SQL Server using Execution Plan properites.| Grant Fritchey
Answering the question, can you see table valued parameters in Extended Events. The answer, is pretty surprising.| Grant Fritchey
