When does SQL Server think YYYY-DD-MM is a valid date?

In this tip, I talk about cases where SQL Server will interpret YYYY-MM-DD as YYYY-DD-MM, which is less than optimal.