Query Store Hints
Query Store Hints provide the ability to add a hint to a statement even if you do not have direct code access.
Menu
Query Store Hints provide the ability to add a hint to a statement even if you do not have direct code access.
I wrote the original Query Store performance overhead post just over two years ago, and just like the data in your database keeps changing, so
Have you ever tried to turn off Query Store when there was an issue, and you thought the problem might be related to Query Store,
When I talk about Plan Forcing I always discuss how users should ALTER procedures when using Query Store, and not use DROP and CREATE. This
If you use Automatic Plan Correction, and thus also Query Store, you may wonder how was a plan forced: manually or automatically with APC? The
This month’s T-SQL Tuesday topic is courtesy of Tracy Boggiano and it’s related to using Query Store! Tracy asked people to write about their
The Query Store feature is a bit unique in that its status can change without user interference, which means it is important to understand how
A question I’ve gotten a few times when teaching relates to database compatibility level and Query Store. I was talking to a client yesterday about
I am thrilled to announce that I will be heading back to London in spring 2020 for a day of Query Store training. The training
Very often I get interesting questions from the community, and most recently someone asked about encrypted stored procedures and Query Store. Here’s the question (paraphrased):
Last week the SQL Server Tools team released a new version of Management Studio, 18.4, and it dropped in the middle of my Query Store
A couple weeks ago I presented for the 24HOP Summit Preview and I had a lot of great general questions about how Query Store
With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.