Query-Performance

Category: query-performance

Fake News about Auto Parameterization/Simple Parameterization

Fake News about Auto Parameterization/Simple Parameterization

I saw a question on Twitter today that took me down a little rabbit hole. And when I go down rabbit holes, I like to blog about it! There’s a TLDR at the bottom of this post if you’re short on time.

Continue reading

Sys.dm_db_tuning_recommendations Makes Suggestions if Automatic Tuning is Not Enabled

Sys.dm_db_tuning_recommendations Makes Suggestions if Automatic Tuning is Not Enabled

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…

Continue reading

New Free Webinars! Index Tuning, Free Q&A, and Isolation Levels

New Free Webinars! Index Tuning, Free Q&A, and Isolation Levels

on March 12, 2018

I’ve got a whole slew of free webcasts and events coming this spring. I’m excited about each and every one of them!

Continue reading

Forced Plan Confusion: Is_Forced vs Use Plan = True

Forced Plan Confusion: Is_Forced vs Use Plan = True

Identifying that a query plan has been bossed around in Query Store can be a bit tricky, because it can appear in different ways.

Continue reading