Posted by Erland Sommarskog on 12/05/41 11:36

serge (sergea@nospam.ehmail.com) writes:
> The mass update is causing this to become:
>
> SELECT dbo.CLIENT.FIRSTNAME,
> dbo.CLIENT.LASTNAME
> FROM dbo.CLIENT
> ...
>
> My goal is to see FROM dbo.CLIENT
> but even the column names are getting the "dbo."
> added, so my question is if there's any performance
> loss or any other side effect if I end up all my columns
> with a preceeding "dbo."?

I doubt that there is any performance loss on the computer side. On
the human side of things, there is likely to be. Personally, I always
use alias to prefix my columns. Having dbo.tablename. repeated all
over the query is a good way to hide a forest putting trees in front
of it.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Is there any performance loss if i have all my columns preceeded with dbo.Tablename?
• Prev in forum: Re: Is there any performance loss if i have all my columns preceeded with dbo.Tablename?
• Thread view: Re: Is there any performance loss if i have all my columns preceeded with dbo.Tablename?

[Reply to this message]