The Query Optimizer is good at working out the best way of getting what you want, far better than you. It works out the best plan, based on what you...
Crazy idea, does anyone know what version the memory leak on stats was in? If I recall there is some sort of memory leak with auto update stats async on....