I explains why I code defensively – matching the case of data type names, even when it is irrelevant.

I explain why you shouldn't bother adding ORDER BY to views in SQL Server.