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.
Ad hoc updates to system catalogs are not allowed. - 26 Nov 2007
Cannot create %S_MSG on view “%.*ls” because it contains the DISTINCT keyword. Consider removing DISTINCT from the view or not indexing the view. Alternatively, consider replacing DISTINCT with GROUP BY or COUNT_BIG(*) to simulate DISTINCT on groupin - 26 Nov 2007
Cannot create %S_MSG on view “%.*ls” because it uses aggregate “%.*ls”. Consider eliminating the aggregate, not indexing the view, or using alternate aggregates. For example, for AVG substitute SUM and COUNT_BIG, or for COUNT, substitute COUNT_BIG. - 26 Nov 2007
Cannot create %S_MSG on view “%.*ls” because it references common table expression “%.*ls”. Views referencing common table expressions cannot be indexed. Consider not indexing the view, or removing the common table expression from the view definition - 26 Nov 2007
Programming Microsoft SQL Server 2005 - 26 Nov 2007
The compute by list does not match the order by list. - 23 Nov 2007