• 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.