Great article.
Would we expect to see the same kinds of performance issues in frequently run queries that do not qualify the owner of the table?
E.g.
SELECT *
FROM table
WHERE foo = 1
vs
SELECT *
FROM dbo.table
WHERE foo = 1
Would it perform locks to see if there is already an execution plan for that query?
Thanks.