October 2012
Trimming time from datetime – a follow-up

I follow up on an earlier post about trimming time from datetime, this time examining the performance characteristics of various methods without data access.

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 (minor) performance hit.