I have a question to know if SQL Server loads in memory all the table (including all the fields) when we do a query like “select field1 from table”. If this table have more fields, are all the table loaded in memory? or just is loading the pages with field1?
Thanks a lot!

I have been trying to know it using profiler but I don’t see the number of bytes loaded from disk.