Register for My Free Session on Execution Plan Forcing
Category:
query-performance
I am excited to be giving a free online session as part of the Idera Live Virtual Conference, 2018!
Category: query-performance
Sys.dm_db_tuning_recommendations Makes Suggestions if Automatic Tuning is Not Enabled
Category:
query-performance
I naturally think about the new sys.dm_db_tuning_recommendations DMV when I’m working with the new Automatic Tuning feature in SQL Server 2017.
But I came across a post by Grant Fritchey recently, in which he remarked in the conclusion…
New Free Webinars! Index Tuning, Free Q&A, and Isolation Levels
Category:
query-performance
I’ve got a whole slew of free webcasts and events coming this spring. I’m excited about each and every one of them!
EstimateRowsWithoutRowGoal helps you see: is it a statistics problem?
Category:
query-performance
, sql-server
SQL Server Management Studio version 17.5 adds a welcome feature for execution plans: a new visual attribute named EstimateRowsWithoutRowGoal.
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.
Can I Force Multiple Plans for a Query in Query Store?
Category:
query-performance
Nope.
At least, not right now.
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.