Estimated Vs Actual rows
I have seen this as a constant struggle to understand even when people come to the performance labs in our environments. Today I got a chance to read this post from Gail Shaw on Estimated rows, actual rows and execution count which are all a common areas of confusion. Gives a very good indicator to what to lookout for …