Reply to Re: Is there any performance loss if i have all my columns preceeded with dbo.Tablename?

Your name:

Reply:


Posted by Erland Sommarskog on 10/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

[Back to original message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация