SQL Server 2019, Row Mode Memory Grant Feedback
Hy Guys, Are you ready for another post? Today we will discuss about another new feature introduced by the last SQL Server 2019 that is called Memory Grant FeedBack for Row Mode . Enjoy the reading mate! A recap! Just to recap what we are talking about in these last posts and where we have arrived . In the past posts we have seen what are the new features introduced by SQL 2019. We have addressed all but one. We have talked about: Table Variables deferred compilation Batch Mode on Rowstore Approx_Count_Distinct function (we also talked about the OPTIMIZE FOR SEQUENTIAL KEY clause) So, what subject do we still have to talk about? well.. Memory Grant FeedBack for Row Mode Many times we have focused on performance. We want to get a Query that is quick to execute and that reads as few pages of memory as possible. This certainly remains true! However, there is another aspect to focus on: the use of memory . Obviously memory is a limited resource and the more the queries requir...