A Seek is good because it quickly finds the data you want. But a residual predicate might be making your Seek almost as bad as a Scan. This session explores what’s going on with that and shows how residuals can pop up in other parts of your plans and cause a lot of pain.
level: 300