Re: prefixing the tables with owner name

From: avnrao (avn_at_newsgroups.com)
Date: 11/17/04 

Date: Wed, 17 Nov 2004 14:25:33 +0530

yes. within stored procedures, if you use owner.objectname - it performs
better.
if you consistently use owner name on the objects referred within a stored
procedure, sql server can use in-memory plan on every execution.
http://www.sql-server-performance.com/stored_procedures.asp

Av.
http://dotnetjunkies.com/WebLog/avnrao
http://www28.brinkster.com/avdotnet

"Anuradha" <Anuradha@discussions.microsoft.com> wrote in message
news:FB2D3385-9DC8-4F37-A45B-D31332710271@microsoft.com...
> Hi,
>
> Will prefixing the table with the owner cause any performance
improvements.
>
> Is it a suggested practice.
>
> thks in advance.

Relevant Pages

  • RE: System Stored Procedure Permissions
    ... The stored procedures you reference are created when you create a diagram ... they are created as 'System' stored procs with DBO as the owner. ... Please let me know the version number of your SQL Server. ...
    (microsoft.public.sqlserver.security)
  • System Stored Procedure Permissions
    ... I have system stored procedures in a databse ... somehow instead of showing the owner as dbo and type as ... database. ...
    (microsoft.public.sqlserver.security)
  • Re: Stored Procedure Owner Issue
    ... "Aaron Weiker" wrote: ... >> analyzer but I can't run these stored procedures from a scheduled job. ... >> to change the owner name for these objects, ... > In order to execute these jobs you have a couple options. ...
    (microsoft.public.sqlserver.programming)
  • How to find owner of objects
    ... I need to find the owner of jobs and stored procedures that have been ... This the notification message I receive: ... of job Restore DukeEDI_TLog has server access (reason: ...
    (microsoft.public.sqlserver.security)
  • Re: Stored Procedure Owner Issue
    ... The stored procedures work when executed from query ... > to change the owner name for these objects, ... In order to execute these jobs you have a couple options. ... login is "raul" and the stored procedure is "test_proc", ...
    (microsoft.public.sqlserver.programming)