protocal layer(API) function in SQLSERVER ARCHITECHTURE?
Hi All, Can I know how the SQL SERVER communicate with clint(format in which it will move data) How the query(exmple select or insert) will executed i.e what happens internally in server? Thanks in Advance.. Manik
Data is moved between client and server using the Tabular Data Stream protocol. This was originally written/developed for Sybase and was incorporated into SQL Server when Microsoft bought the source from Sybase. [A link to the MS implemented TDS protocol] A query, or results of a query are transfered using this protocol. What actually happens with a query when it arrives at the server is a little more involved. You need to take a look at the Query Optimizer, here is a video from [Conor Cunningham at SQLBits] - he is part of the query optimizer team at Microsoft, he writes the magic inside the black box that is the QO of SQL Server. Put a saftey helmet on, get a nice drink and try to understand all that he says - be aware, this is an hour long video! :