We're using an 18-character alias with no issues so far, even though an instance name is limited to 16 characters.The length of the alias should be mentioned on this page - either that there is no specific limit, or what the limit is, or any recom...

As of SQL 2008 R2, table-valued parameters are inherently optional in the EXECUTE statement; for example:SELECT COUNT(*) FROM @MissingTableParm returns 0 (zero), not an error or warning, if @MissingTableParm is not specified in the EXECUTE statem...

This behavior should either be documented (okay) or changed (better). For the following error: Msg 8152, Level 16, State 14, Line 1 String or binary data would be truncated. The statement has been terminated. ... no files are generated by the...

I believe the NOTE on this topic is missing the word "cascading", as in the following:INSTEAD OF UPDATE triggers cannot be defined on a table that has a foreign key defined by using an UPDATE cascading action.

For example, the following LIKE clause with two ranges per clause can be used to check columns with HTML hexadecimal "color" strings:SELECT * FROM TableName WHERE ShouldBeHex NOT like '[0-9A-F][0-9A-F][0-9A-F][0-9A-F][0-9A-F][0-9A-F]'