What sql net-lib should I use to improve the speed of my network connections? Answer:
The TCP/IP Sockets is the most fastest sql net-lib.
You can see the difference in responses times between any of the net-libs
only on the slow network connections, on the normal LAN, you cannot see the
difference in responses times.
This is from SQL Server Books Online:
In general, sockets are preferred in a slow LAN, WAN, or dial-up
network, whereas named pipes can be a better choice when network
speed is not the issue, as it offers more functionality, ease of
use, and configuration options.