Posted by masri999 on 10/04/06 09:07

Hello,

I need a clarification on the mechanism of sql server fetches records
to memory (buffer)

Example: A Table ( Table1 ) having 10 Columns
(column1,column2,column3,column4 etc)

When SELECT column1,column2 FROM Table1 is executed

Whether all columns are trasnferred to the server memory from the disk

OR only column1 and column2 are read from disk to memory .

My assumption is that, entire page (8K) containg the rows with all the
colunmns are transferred to the memory and from the memory the select
columns are displayed .

Please confirm

Thanks

M A Srinivas

• Next in forum: Re: CONTAINS in SQL Server
• Prev in forum: Date overlapping
• Thread view: Calrification on number of columns fetched to server memory

[Reply to this message]