You are here: Re: sql 2005 « MsSQL Server « IT news, forums, messages
Re: sql 2005

Posted by Greg D. Moore \(Strider\) on 12/07/06 04:45

"davep" <dvs_bis@sbcglobal.net> wrote in message
news:GQHdh.5113$hI.3104@newssvr11.news.prodigy.net...
>I have tcpip enabled....not a problem
> i was just wondering if is should also
> Enable Named pipes
>
> with tcpip over named pipes
>
> Basicly Because i do not know....
> What is the best Performance and or Practices

Best practice, optimize your queries. Return only the data that is needed.
Avoid stuff like select * from FOO.

Network protocol will be one of the smaller performance tweaks you can make.


>
> tia
> Dave
>
> "Jonathan Roberts" <gremln007@diynics.com> wrote in message
> news:kLGdh.8336$8H6.2308@newsfe22.lga...
>> davep wrote:
>>> new bie....i have a server
>>> for best preformance should i
>>> set protocols to tcpip only or
>>> tcpip, named pipes and tcpip over named pipes
>>>
>>> thanks
>>> dave
>>>
>>>
>>
>> How do you connect from your application(s)?
>
>

 

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

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