We use TCP/IP.

This is from Inside Microsoft SQL Server 2000 by Kalen Delaney.

quote:

---

Microsoft internal testing has found the TCP/IP Sockets Net-Library to be the fastest networking choice, although in a typical LAN you rarely see the network as a performanc bottleneck. In a low-speed WAN, however, this can be an important issue. Some network administrators have also been concerned about potentially reouting NetBIOS traffic across their LANs and WANs. However, if SQL Serve is not using the Named Pipes Net-Library and the Multiprotocol Net-Library is not using named pipes under the covers for IPC, SQL Server is not using NetBIOS at all and this is not a concern.

---

I have also seen comments elsewhere that TCP/IP is better for security.

-SQLBill