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.
The PATINDEX function operates on char, nchar, varchar, nvarchar, text, and ntext data types only. - 14 Aug 2007
The xml data type cannot be compared or sorted, except when using the IS NULL operator. - 14 Aug 2007
The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator. - 14 Aug 2007
The data types %s and %s are incompatible in the %s operator. - 14 Aug 2007
Invalid PERCENT tablesample size “%f” for table “%.*ls”. The PERCENT tablesample size must be between 0 and 100. - 14 Aug 2007
Invalid ROWS value or REPEATABLE seed in the TABLESAMPLE clause for table “%.*ls”. The value or seed must be an integer. - 14 Aug 2007
Cannot use a CONTINUE statement outside the scope of a WHILE statement. - 08 Aug 2007
Cannot use a BREAK statement outside the scope of a WHILE statement. - 08 Aug 2007
Fillfactor %d is not a valid percentage; fillfactor must be between 1 and 100. - 08 Aug 2007
Each GROUP BY expression must contain at least one column that is not an outer reference. - 08 Aug 2007
© 2014 SQL Server Performance. All Rights Reserved