1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

Explain about protocol layer present in SQL server?

Question Posted / nirpendra rai


Explain about protocol layer present in SQL server?..

Answer / Mahipal Singh

SQL Server communicates with clients using a layered protocol stack. The primary components of the protocol layer are:n
1. Tabular Data Stream (TDS): A binary protocol used for communication between SQL Server and clients. TDS defines various frames for transmitting data, metadata, and control messages.n
2. Network Library: Handles network I/O tasks like opening connections, reading, and writing data packets.n
3. TCP/IP: The primary transport layer protocol used by the network library for communication between SQL Server and clients over a network.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What are the advantages of stored procedure in sql server?

1 Answers  

Explain difference between control flow and data flow?

1 Answers  

how to copy sysdatabase file from c: Drive to D: Drive in SQL Server.

6 Answers   IBM,

Explain the microsoft sql server delete command? : SQL Server Architecture

1 Answers  

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

1 Answers   HCL,

could you please reply for these question: 1.About Use Apply? 2.Avoid cursors - When we have a situation that we can not avoid the use of cursor than what is the alternate solution? is there anything we can use instead of cursor to perform the desired task? which optiomize the peroformance too. 3.What is computed columns? Thanks in advance. Regards, Rupesh

3 Answers  

What are wait types?

0 Answers  

what stored procedure can you use to display the current processes? : Sql server administration

1 Answers  

How will you hide an attribute? : sql server analysis services, ssas

1 Answers  

plss anybody specify tha constrian management system in dbms

1 Answers   Police Constable,

What does the on delete cascade option do?

1 Answers  

One table how may column and Primary key

3 Answers  

For more SQL Server Interview Questions Click Here
Categories