sql 2005

[davep]

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

[Jonathan Roberts]

Re: sql 2005

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)?

[davep]

Re: sql 2005

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

tia
Dave

"Jonathan Roberts" <gremln007@diyn ics.comwrote in message
news:kLGdh.8336 $8H6.2308@newsf e22.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)?

[Jonathan Roberts]

Re: sql 2005

davep wrote:

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
>
tia
Dave

I would turn it off if you don't need it.

[Greg D. Moore \(Strider\)]

Re: sql 2005


"davep" <dvs_bis@sbcglo bal.netwrote in message
news:GQHdh.5113 $hI.3104@newssv r11.news.prodig y.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@diyn ics.comwrote in message
news:kLGdh.8336 $8H6.2308@newsf e22.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)?

>
>

[davep]

Re: sql 2005

Thanks all
dave

"davep" <dvs_bis@sbcglo bal.netwrote in message
news:gqGdh.2727 8$wP1.2877@news svr14.news.prod igy.net...

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