Tip: T-SQL Performance–Stored Procedure Names

Avoid prefixing your Stored Procedure names with sp_.

SQL Server first checks in the master database even when the Schema name is provided.

?

Visit the DevX Tip Bank

?

Share the Post:

Related Posts

Increased hacking, phishing schemes, and costly ransomware events have pushed multi-factor authentication into the category of "must-have."

Multi-Factor Authentication (MFA) Has ‘Graduated’ to Must-Have

The internet is a vast and powerful place. It is constantly fueling innovation and bringing the world together. Even so,

The rapid growth of the gig economy has produced massive changes in the way peer-to-peer enterprises around the world do business.

Tech Trends in the Gig Economy

As our modern world continues to evolve, the relationship between technology and business is adapting constantly. The rapid growth of