Here is another new year gift from Microsoft for the SQL Server users, specifically for 2005 version - release of SQL Server 2005 Best Practices Analyzer (January 2008). BPA's job is to gather data from Windows and SQL Server configuration settings. There are pre-defined list of SQL Server 2005 recommendations...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
(Weblog)
by
Anonymous
on
01-25-2008
Filed under: sql server, microsoft, download, best practices, 2008, ctp, analyzer, 2005, Analysis Services, extent, rtm
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...