Frank Kalis

Frank Kalis
http://www.insidesql.org/blogs/frankkalis/

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 conversion from datetime data type to smalldatetime data type resulted in a smalldatetime overflow error. - 12 Jul 2009

Cannot use index “%.*ls” on table “%.*ls” in a hint. XML indexes are not allowed in hints. - 12 Jul 2009

Index “%.*ls” on table “%.*ls” (specified in the FROM clause) is disabled or resides in a filegroup which is not online. - 12 Jul 2009

The index ID %d on table “%.*ls” (specified in the FROM clause) is disabled or resides in a filegroup which is not online. - 12 Jul 2009

The TABLESAMPLE clause can only be used with local tables. - 12 Jul 2009

Syntax error: Duplicate specification of the action “%.*s” in the trigger declaration. - 12 Jul 2009

An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or [] are not allowed. Add a name or single space as the alias name. - 12 Jul 2009

The IDENTITY function cannot be used with a SELECT INTO statement containing a UNION, INTERSECT or EXCEPT operator. - 12 Jul 2009

The NOLOCK and READUNCOMMITTED lock hints are not allowed for target tables of INSERT, UPDATE or DELETE statements. - 12 Jul 2009

Cannot create the foreign key “%.*ls” with the SET NULL referential action, because one or more referencing columns are not nullable. - 12 Jul 2009

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |