I run some tests to challenge the notion that CHARINDEX is always faster at pattern matching than LEFT and LIKE.

I talk about two core issues to consider when choosing a standard for stored procedure names.