SqlServer-QA.net

You all know that it is a best practice to use the schema qualified tables or views for the better management and performance (sometimes). As the Best Practices Analyzer tool which will be a part of SQL engine from 2008 version onwards confirms that this rule doesn’t check schema qualification on temporary tables. As usual the BP tool flags the ...