What is a Named Pipe in MS SQL Server?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What is a Named Pipe in MS SQL Server?

A Name Pipe is communication interface that allows MS SQL Server to listen and receive client requests like a TCP/IP port. The default Named Pipe is \\.\pipe\sql\query.

(Continued on next question...)

Other Job Interview Questions

• Is T-SQL language syntax case-sensitive?
• Does MS SQL Server support IPX/SPX?
• What is the meaning of the following T-SQL command: SELECT TOP 10 * FROM user WHERE last_name = 'Johnson'
• When revoking one security role from a user, does it affect other security roles granted to same user?
• What is an Index in MS SQL Server?
• What is the purpose of IAM (Index Allocation Map) in MS SQL Server?
• What is the meaning of an Outer Join operatin of two tables?
• Does MS SQL Server support IPX/SPX?
• In what situation you should the "sp_showfilegroup" stored procedure?
• What is the main purpose of assigning a user with the "processadmin" role?
• More...