| 
 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] 
 |