Hi,
This is a general question to understand when the paging file is used and when the tempdb spills occur.
As per what i know, when SQL is short on memory during query processing, it creates more space in memory by swapping out contents to paging file. if Paging file is used during memory shortages, how is this different from tempDb spills.
Please can someone explain on this forum explain the 2 concepts: use of Paging file, tempdb spills.
thanks