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!
Category: query-performance
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.
Does a Clustered Index Give a Default Ordering?
Category:
query-performance
, sql-server
I recently got a great question: if I order by a column where all rows in that column have the same value, will SQL Server then order the results by the clustered index key?
Auto-Tuning and the #1 Mindset Problem I Had as a DBA
Category:
query-performance
, sql-server
A few folks have asked: will auto-tuning and adaptive query plans mean the end of performance tuning jobs for SQL Server? In this week’s episode, I talk about why I’m excited about those features rather than afraid of them.
Digging into this problem, I share the #1 mindset problem I had as a DBA, why this mindset is so common among database professionals, and a daily habit that can change your approach to new technology.