Solved

Named Pipes, TCPIP, Shared Memory, etc for SQL Server

Posted on 2011-02-15
2
763 Views
Last Modified: 2012-05-11
Can someone please explain the differences regarding the various connection methods available for SQL Server (2005 and 2008 specifically)

I've seen the Wikipedia stuff, so please no links to content of that nature

I'm more interested in things like why I should choose one method over another, for exampe - or are there any drawbacks to enabling ALL of them, etc etc. What are the advantages/disadvantages of doing these things?



0
Comment
2 Comments
 
LVL 15

Accepted Solution

by:
mattisflones earned 500 total points
ID: 34896098
There are no advantages/disadvantages other than the obvious ones.. TCP/IP can be accessible to the public with all the security concerns that brings, can be impacted by LAN performance and so on.. Shared memory is for internal use, and so on.. Just different protocolls and surfaces.

And as with everything else, enable only what you will use.


I find this short article to be "all you need...", atleast for the basics of choosing.

http://msdn.microsoft.com/en-us/library/ms187892.aspx
0
 
LVL 84
ID: 34915513
Thanks. That article did explain the basics of the various technologies, and I'll look further to find details as needed.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
tools to scan a SQL server's problem 14 27
SQL Log size 3 18
MS SQL Delete Duplicate Rows Only 2 18
MS SQL + group by time 4 15
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

837 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question