You are here: Re: Is there any performance loss if i have all my columns preceeded with dbo.Tablename? « MsSQL Server « IT news, forums, messages
Re: Is there any performance loss if i have all my columns preceeded with dbo.Tablename?

Posted by John Bell on 10/17/49 11:36

Hi

It is better to have some prefix than non at all in a multi-table statement,
therefore a consistent application of either method is the most important
IMO.

John

"serge" <sergea@nospam.ehmail.com> wrote in message
news:lVuvf.41896$Kf1.817743@weber.videotron.net...
> Thank you John and Erland.
>
> In our shop some people are against using aliases
> believe it or not. They would rather type the full
> table name and not use an alias.
>
> Me I am just happy I'll be able to add all the
> missing dbo. to comply with SQL Best Practices
> Analyzer and gain performance (however slight
> it may be).
>
>
>

 

Navigation:

[Reply to this 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

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