March 17, 2009 at 10:43 pm
Hi All,
can any one please explain me if user stored procedures and user defined funtions is having prefix sp_userprocedures; and fn_userfuntions.
Like this your developers are created so many for so many databases;will it be decrease the performance of the database
thanks, kumar
March 18, 2009 at 3:56 am
No this should not be a performance problem.
I would advice you to avoid "sp_" and "fn_". Microsoft is using this prefixes and you may run into ambiguous name problems if you use it.
A common guideline is:
"ufn_" for user functions
"usp_" for user stored procedures
Greets
Flo
March 18, 2009 at 4:04 am
It is common wisdom that using sp_ will decrease performance since these procedures will first be searched within the Master database rather than in the database that it was created in.
Regards,
Justin
March 18, 2009 at 4:10 am
Ouch! So sorry for my wrong information... I never did use so I never noticed 😉
Thanks to Justin!
Flo
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply