Thanks

So if a query is submitted to SQL and the pages need to be brought into memory from disk and there is not enough memory to accomodate those pages, SQL pushes is into tempdb, right?

Does is just push the pages that wouldn't fit in memory into tempdb or does it fulfill the entire transactions pages?

Is this where memory pressure in SQL server comes from?

Thanks