While I realize that select * from DimEmployee is valid if the table is in the dbo schema, I’d like the option to automatically add it when writing T-SQL.
I believe it’s just a best practice to always specify schema, and it is in fact one of our programming standards.