Saturday, 31 August 2013

Sql server prefix difference between custom and "dbo"

Sql server prefix difference between custom and "dbo"

I've a shared web hosting and Sql Server with it.
When I create a View or Stored Procedure via Sql Server Management Studio
it appends as prefix my username instead of dbo.
Suppose my username is UserJustWork which I use while connecting to remote
sql server.
SPs and Views are being named as:
UserJustWork.Users_Get -- SP
UserJustWork.ActiveUsers -- View
According to hundreds of people (e.g. SQLMenace's answer) using prefix
makes sql faster on finding object.
Sure, it is shared sql server (that means there are so many people using it).
What I wonder is that does it make better performance using UserJustWork
than dbo?

No comments:

Post a Comment