Information générale
Forum:
Microsoft SQL Server
Titre:
Dbo as default owner
While at the GLGDW Mike Levy pointed out to me that prefixing all your tables with "dbo." will give you a performance gain. This is because SQL server will look for a table under the login name first and then default to dbo. So, now knowing this is there any way to tell SQL Server to use dbo as the default owner when I run a query that doesn't prefix "dbo" to all the table names. I really dont want to go though all my stored procedures and add dbo.
Eric
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement