Table variables and row estimations – Part 2

Hello again, On my previous post, we covered how the Query Optimizer handles row estimation when using Table variables under specific conditions. Following up on that, I will demonstrate other scenarios where the Query Optimizer must try to optimize queries when no statistics and histograms are available. In the 2nd example of the series I…