DLathrop (6/9/2010)
Full three part naming helps the query optimizer recognize and reuse queries in the execution plan cache.
I understand that you need to use two part naming, but I have never heard that you have to use three part naming for the optimizer to recognize and reuse execution plans. Do you have a link to any documentation that supports this?