SQL Server and the Adaptive Join feature: "Adaptive Join" Vs. "wrong cardinality estimate" and "Uneven data distribution"
Hi Guys, I hope everything is fine for you! It is Christmas and it's time for the wishes! So Merry Christmas and a happy new year filled of peace, health, love and new projects to start! I remember that some posts ago we talked about SQL Server 2019, Row Mode Memory Grant Feedback . On that occasion I presented the latest of the new feature that SQL Server 2019 had introduced. Today i want to talk to you about another feature, this time introduced by SQL Server 2017. I will do it because it is important from a performance point of view! Today infact we will talk about Adaptive join . Enjoy the reading mate! Adaptive Join I know i have already used the image below but i like it because it is very clear for me. We have already talked during past posts of all the new feature (in green) introduced by SQL Server 2019. Today we will talk about Adaptive Join that is a feature part of a family called " Adaptive Query Processing " (or "Adaptive QP") introduced by ...