Especially with Capture Mode added in 2019 that solved a lot of the headaches people were experiencing. #QueryStore

Milos Radivojevic talking about solving perf problems with #QueryStore available on #SQLServer and #AzureSQL and forcing good execution plans🔧 in some cool demos :)

#DataSatSlo #DataSatSlo2025

Does Query Store plan forcing work on queries using the RECOMPILE hint? It's 2AM and I'm curious if Query Store plan forcing works on queries that use the RECOMPILE hint (aka OPTION(RECOMPILE) ).

New blog post:
In which I test if Query Store plan forcing works on queries that use the RECOMPILE hint and run into an interesting scenario with plan forcing and new indexes.
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql #querystore

@sqlballs.bsky.social just said @erinstellato.bsky.social is brilliant referring to her blogs on #QueryStore. I would have to agree!!!

Exploring the Query Store on Secondary Replicas in SQL Se...

[Blog] Exploring the Query Store on Secondary Replicas in SQL Server 2022: www.sqlpassion.at/archive/2023/11/22/explo... #sqlserver #sqlpassion #availabilitygroups #querystore

[Blog] Exploring the Query Store on Secondary Replicas in SQL Server 2022: www.sqlpassion.at/archive/2023... #sqlserver #sqlpassion #availabilitygroups #querystore

RC0, and I still don't know if @BrentO owes me money #QueryStore #StandardEdition

"@sqlcheesecake: "I would expect this to be 'broadly available'"
#QueryStore" Hey @BrentO @BrentO...

NERDGASM #querystore #sqlpass