I have experience lots a time, where people use to name there stored procedure with the prefix sp_Name1.. like this, but this is actually not a good practice, it may lead to degrade performance of you SQL server.
The reason behind this is, whenever you write stored procedure with a prefix sp, the SQL Server first check the stored procedure in System Stored Procedure, and then in the users defined stored procedure. Instead if you gave prefix other then 'sp' for example proc_getData like this the SQL server first check the Stored procedure in the user Stored procedure directory.
So do the better practice and enjoy T-SQL programming.
About Me
- Vikram Mahapatra (Viki)
- Mumbai, Maharastra, India
- He has more than 7.6 years of experience in the software development. He has spent most of the times in web/desktop application development. He has sound knowledge in various database concepts. You can reach him at viki.keshari@gmail.com https://www.linkedin.com/in/vikrammahapatra/ https://twitter.com/VikramMahapatra http://www.facebook.com/viki.keshari
I hope this will be helpful to the T-SQL beginners.
ReplyDelete