Details

Added by on 2014-05-15

Aaron Bertrand explains what the SP_ prefix is and discusses the performance issues with using it when you call a stored procedure. He also mentions a blog post he wrote about the SP_ prefix, which can be found at SQLPerformance.com/sp_prefix.

Category: Quick Tips    Tags: , ,

Leave a Reply

Your email address will not be published. Required fields are marked *

*

1 Comment

  • Lance Andrewes 3 years ago

    Every now and then someone asked me to justify “rules” that I put in a set of database development standards a good 10 years ago. It’s therefore nice to see current evidence that it still holds true. I’m actually surprised that the impact is still significant. Thanks Aaron.