There’s an interesting post over at the SQL Programmability & API Development Team Blog discussing dynamic object name resolution and default schemas. In particular it discusses the differences which exist between SQL Server 2000 and 2005, and possible (fixable) decrease in query throughput when using unqualified object references.