Weaponizing Query Store
I may have occasionally talked about the importance of Query Store, but today I want to emphasize just how much Microsoft is weaponizing query store. Of course, I don't mean they're creating the Death Star or something, I simply mean they're taking the information that Query Store gathers and using that to enable a number of new performance enhancements within SQL Server. Intelligent Query Processing Starting back in SQL Server 2017, Microsoft started making improvements to how queries get processed. The early stuff was mostly about interleaved execution, basically allowing for the ability to adjust an execution plan on the fly. This was expanded quite a bit in 2019. Follow the link for a great graphic showing how this stuff has progressed. SQL Server 2022, releasing soon I'm sure (no,…