Friday, February 27, 2015

Regarding Network buffer and datareader data fetch c#

i try to know few simple answer and those are point wise


1) suppose i issue a sql query like Select empid,Name from employee table there are 10,000 rows then what will happen. how much data sql server will send to client?


2) suppose network buffer could store 8kb data then sql server may send more than 8kb data or sql server know the client pc network buffer size in advance?


3) suppose first 100 data is stored in network buffer so when again db trip will occur for next 100 data then same query will executed so how sql server will know that time sql server has to send data from 101 to 200 etc?


i like to know the above internal process in details regarding interaction between sql server and data reader. so please share the knowledge if some one knows it in details.


No comments:

Post a Comment