Plan Forcing in SQL Server
Last month I was in Portugal for their SQLSaturday event, and I spent a lot of time talking about Plan Forcing in SQL Server –
Last month I was in Portugal for their SQLSaturday event, and I spent a lot of time talking about Plan Forcing in SQL Server –
If you are trying to execute an ALTER DATABASE command to change a Query Store option (e.g. turn it off, change a setting) and it
I am so excited to announce that I am presenting a full day of Query Store Training, in-person, this September in Lisbon, Portugal! The SQLskills
Last week I presented a session on Query Store and when talking about the settings I mentioned that monitoring space used by Query Store is
This is question I’ve gotten a few times in class…Can you force a plan for a different query with Query Store? tl;dr No. Assume you
I’ve had two comments recently on my blog about Query Store causing the plan cache to be flushed. There was a known issue related to
Way back in 2016 I wrote a post trying to find out why people were not using Extended Events. See, I really like Extended Events,
In the past week I’ve used Query Store to troubleshoot performance issues for two different customers running SQL Server 2016 and higher. I’ve presented a
In early January Microsoft announced that Connect, the method for filing SQL Server bugs and feature requests, was being retired. It was replaced by User
There is a Query Store fix in the latest Cumulative Updates of SQL Server 2017, and if you are keeping current with the latest cumulative
If you’ve ever been to one of my sessions you know that I really like demos. I find they can illustrate how things work extremely
In SQL Server 2017 there are nine (9) settings related to Query Store. While these are documented in sys.database_query_store_options, I often get asked what the
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.