Updating Statistics with Ola Hallengren’s Script
I am a HUGE fan of updating statistics as part of regular maintenance. In fact, if you don’t know if you have a step or
Menu
I am a HUGE fan of updating statistics as part of regular maintenance. In fact, if you don’t know if you have a step or
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,
This post originally went live on May 11, 2018, but modifications were made on May 14, 2018 after some additional internal discussions with Microsoft. Changes
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
I am late to the party (I am often late to the party, just ask Aaron Bertrand, this month’s host). I chose door #1 for
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
Last week at the PASS Summit I presented a pre-con and general session on Query Store. I had several questions related to Query Store and
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.