Frank is working as a Development DBA / Data Architect for a large financial institution in Switzerland. He is a Microsoft MVP for Windows Server System - SQL Server since April 2005.
Cannot create %S_MSG on view “%.*ls” because it references derived table “%.*ls” (defined by SELECT statement in FROM clause). Consider removing the reference to the derived table or not indexing the view. - 01 Aug 2009
Cannot create %S_MSG on view “%.*ls” because it uses aggregate “%.*ls” with the DISTINCT keyword. Consider not indexing this view or eliminating DISTINCT. Consider use of a GROUP BY or COUNT_BIG(*) view to simulate DISTINCT on grouping columns. - 01 Aug 2009
Cannot specify included columns for a clustered index. - 01 Aug 2009