0

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 instead of dbo?

Community
  • 1
  • 1
JustWork
  • 1,944
  • 3
  • 22
  • 34
  • 1
    what you call `prefix` is actually `Schema`, the best reason to have schema for `users` in a shared `sql server` is to bring isolation among different users. you can read a bit more [here](http://www.quackit.com/sql_server/sql_server_2008/tutorial/sql_server_database_schemas.cfm) – Luis LL Sep 01 '13 at 04:59
  • It doesn't make any difference but as you said its shared hosting so its good to give custom name. – Vicky Thakor Sep 01 '13 at 11:37
  • Why is it good to give custom name than dbo? I am already requesting with my username and password, so sql knows which account's function will be executed even there are other same named functions. So, why use custom name? – JustWork Sep 02 '13 at 02:50

0 Answers0