I think, again I think, That when an SQL statement is executing, it will create a temp file on the disk when it is a large query. Cursors are also held on disk if ram is used and virtual memory takes over.