Forced Plan Confusion: Is_Forced vs Use Plan = True
Category:
query-performance
, sql-server
Identifying that a query plan has been bossed around in Query Store can be a bit tricky, because it can appear in different ways.
Why I Love the Automatic Plan Correction Auto-Tuning Feature
Category:
course-announcements
I’m thrilled to have just finished and published a new course on Automatic Tuning in SQL Server. This feature is available in SQL Server 2017+ and Azure SQL Database.
Update: this course is now open and totally free to all.
Can I Force Multiple Plans for a Query in Query Store?
Category:
query-performance
Nope.
At least, not right now.
Infographic: Conference Prep for Anxious Folk
Category:
community
, infographics
I’m honored to be heading to the Microsoft MVP Summit. I really enjoy this conference– it’s not my first time going, so I know the ropes. I’m looking forward to seeing a bunch of old friends AND to connect to lots and lots of new people.
But even though I am familiar with the conference, I have a list of things I do to get ready and prepare. That’s because…
Using YouTube Captions & Transcript to Find Content in a Long Video
Category:
query-performance
This week, I was pretty pumped to see that PASS published Erin Stellato (twitter) and Dejan Krakovic’s (linked in) excellent session on Query Store to the public.
I attended this session live at the conference, and I remembered that there was one specific part on memory limits in Query Store that I wanted to watch again. I’d jotted down a note about it, but things were flying by and my note was gibberish.
When Should I Use Explicit Transactions for Single Statements?
Category:
tsql
, sql-server
I got a great question about transactions by email recently about transactions.
New SQLChallenge: Defuse the Deadlock
Category:
monitoring-troubleshooting
, sql-server
When I first created SQLWorkbooks, I distilled what it was all about down into one sentence: “Learn SQL Server by Solving Problems.”
This month, I introduce my first SQLChallenge, which distills that down into practice. The SQLChallenge features 23 minutes of video with scripts that you can use to reproduce and solve the problem yourself.