Is the sp_ prefix still a no-no?

I show several reasons why you should stop using the sp_ prefix on stored procedures in SQL Server, including a performance hit.