Using Query Store Hints to Optimize Memory Grants, Improving Performance | Data Exposed

Query store hints enables changing query plan shapes without modifying application code. In this episode of Data Exposed with Denzil Ribeiro, we will look at an example of improving the performance of bulk loading data using query store hints. [00:30] Introduction Denzil Ribeiro[01:40] Memory Grants Overview [02:49] Demo[13:05] Getting Started Resources:Performance impact of memory grants on data loads into Columnstore tables

Om Podcasten

Channel 9 is a community. We bring forward the people behind our products and connect them with those who use them. We think there is a great future in software and we're excited about it. We want the community to participate in the ongoing conversation. This is the heart of Channel 9. We talk about our work but listen to the customer.